Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65431 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / tripurari
truncate id ddl command .so it can't store data into redo log files, so it can't be rollback.
Delete is dml command so it contains data into log files so it may be rollback.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Where in the Oracle directory tree structure are audit traces placed?
Difference between transaction type and transaction sources. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Explain the use of table functions.
can we use lexical perameter in oracle plsql if yes how
What is the use of lockboxes? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Is there any link between pr form(purchse requisition)and po form(purchase order)
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
