diff between DELETE and TRUNCATE?.
Answer Posted / padma
delete comd is used to delete not a specific record rather
all records without affecting the structure of the records
truncate comd is used to delete all the records from
existing table,retaining the structure o that table.
by using delete comd v can rollback all the delete
records .it is record level cmd
wherease truncate cmd v cannot rollback. it is table
level cmd
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is difference between sid and service name in oracle?
Explain user account with reference to oracle.
How to create an initialization parameter file?
definition of cluster and non-clustered index?
What is Undo Management Advisor in Oracle?
How to put more than 1000 values into an oracle in clause?
How are extents allocated to a segment?
What are ddl statements in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How to define a data field as not null?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain the use of indexes option in exp command.
What is a synonym? What are its various types?
How would you best determine why your MVIEW couldnt FAST REFRESH?