what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / 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 |
Post New Answer View All Answers
Can we modify approve purchase order?if yes what is navigation?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
How many segment are present in Oracle Manufacturing
What is auto invoicing? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
HOW TO SPOT AHIERARCHY?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain the payment term in ar. : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable