Are truncate and delete commands same? If so why?
Answer / Mukesh Gupta
"No, Truncate and Delete are not the same in Oracle. Truncate removes all rows from a table instantly but preserves table properties such as constraints. Delete removes rows one by one, possibly triggering cascading deletes if foreign keys exist. Truncate also generates fewer audit logs than Delete."
| Is This Answer Correct ? | 0 Yes | 0 No |
What is redo log?
Can a Tablespace hold objects from different Schemes ?
what is a cartition product?
what are the database links ?
How to display employee records who gets more salary than the average salary in the department?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How do I recompile a procedure in oracle?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What is object data modeling?
What is the recommended interval at which to run statspack snapshots, and why?
How to use like conditions in oracle?
how to tune oracle sql queries pls tell me step by step. urgent pls