what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58470 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
key flexfield structure
What do you mean by Oracle MEDIA RECOVERY?
Give two methods you could use to determine what DDL changes have been made.
What is Tax Categories?
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.
What is an Oracle database Partial Backup?
8. Supporting AP, AR and GL?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the difference between recovery and restoring of the oracle database?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
How would you determine who has added a row to a table?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
how to write customizations in po
default triggers available for reports
