Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 45735 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What mean sql?
What is the most important ddl statements in sql are?
What is the use of %rowtype?
Differentiate pl/sql and sql?
how to create a new view in mysql? : Sql dba
What is group by in sql?
Why stored procedure is faster than query?
how to increment dates by 1 in mysql? : Sql dba
Which join is default?
What are the two different parts of the pl/sql packages?
What is synonyms?
explain commit and rollback in mysql : sql dba
What is percent sign in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Can we use insert statement in function?
