diff between DELETE and TRUNCATE?.
- 14 Answers
- 18958 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / ron
again to add to my earlier positing, many forget that is the
table has materialized view log truncating table will
corrupt the materialized view.
in that case you have to user:
truncate table schema_name.table_name purge materialized views;
you can read more about it here:
http://www.psoug.org/reference/truncate.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Explain the use of grant option in exp command.
How to use "while" statements in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is the difference between substr and instr?
What is the difference between hot backup and cold backup in oracle?
Explain the use of record option in exp command.
What is the usage of analyze command in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
How to check the server version in oracle?
What are the various oracle database objects?
What are the different types of record groups in oracle? Explain each of them
what is insert all statement in sql
How can we force the database to use the user specified rollback segment?
What is Undo Management Advisor in Oracle?
