Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66333 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amit
In Truncate only data are remove from table
where as in delete structure of table are delete.
| Is This Answer Correct ? | 3 Yes | 9 No |
Answer / rams
TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.
DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.
| Is This Answer Correct ? | 13 Yes | 21 No |
what is debit memo and credit memo in AR?
Can we get the deleted Record again if the delete transaction has been committed.
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
When creating a user, what permissions must you grant to allow them to connect to the database?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What is supporting issues GL AP and AR?
How would you determine the time zone under which a database was operating?
Why more redos are generated when the oracle database is in begin backup mode?
Oracle General 
