Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22119 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / manoj.oracle
Delete command is a dml command
truncate command is a ddl command
Delete command has a where clause.
truncate hasn't where clause.
Delete doesn't release memory space(means we can rollback
the deleted rows)
truncate releases memory space(means we can't rollback)
By using synonym we can delete a rows(Delete command).
By using synonym we can't delete a rows(Truncate command).
| Is This Answer Correct ? | 29 Yes | 0 No |
Post New Answer View All Answers
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to speed up webrick?
How to start a specific oracle instance?
Why do we use bulk collect in oracle?
How to write a query with a left outer join in oracle?
Can you have more than one content canvas view attached with a window ?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Explain the use of inctype option in exp command.
What is concurrency in oracle?
How to write numeric literals in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How a database is related to tablespaces?
What is proxy method?
