what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58209 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / anup.wilson
hii every one ... i want to say that delite is --dml and
truncate is ddl ..nxt thing about roll back ..through
delete we roll back untill unless we are not COMMIT IT..
IF WE COMMIT AFTER DELETE ..WE CANT ROLL BACK IT
...
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What is supporting issues GL AP and AR?
Explain how to close periods in ar. : oracle accounts receivable
Are These Dff's Flexible?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
default triggers available for reports
Give two methods you could use to determine what DDL changes have been made.
difference of using cursor for loop and open,fetch,close.which one is better
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
How would you go about increasing the buffer cache hit ratio?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Where in the Oracle directory tree structure are audit traces placed?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
