Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 67116 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / vasanth
Truncate
1.Truncate Can be DDL Command.
2.it can be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is the difference between oracle media recovery and crash recovery?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
key flexfield structure
Why more redos are generated when the oracle database is in begin backup mode?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
how to replace not in with not exist?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Difference between transaction type and transaction sources. : oracle accounts receivable
How to clone the database using RMAN back
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
what is the link between suppliers and banks in ap module in oracle apps? And also query?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
