Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 6152 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mkjmkumar
Delete :
1. It is a DML
2. Speed is Slow
3. We can Use Where Clause.
4. Check Constraints Before delete.
Truncate
1. It is a DDL.
2. Speed is Fast
3. We Cant Use Where Clause
4. Delete All Rows without check of constraints.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / zikku
Truncate command permanently deletes the information from a
table even after rollback we can't get that information.
Delete command temporarily deletes information from a table
after rollback we can get the information back.
| Is This Answer Correct ? | 5 Yes | 0 No |
DELETE: IT IS A DML COMMAND(DATA MANIPULATION LANGUAGE) .
IT DELETES DATA MEANS (DELETES ALL RECORDS) IN TABLE.
BUT STRUCTURE WILL BE THERE.
AND
DATA DELETES TEMPERORLY.
THEN USE ROLLBACK WE CAN GET THE DATA.
TRUNCATE: IT IS A DDL COMMAND (DATA DEFNITION LANGUAGE).
TRUNCATE ALL RECORDS IN A TABLE.
BUT STRUCTURE WILL BE THERE.
BUT DATA GOES PERMINANTLY.
WE CANT USE ROLLBACK HERE.
IT SHOLUD NOT WORK. WHY BCZ DATA TRUNCATES
PERMENANTLY.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the importance of batch source set up in ar? : oracle accounts receivable
Give the two types of tables involved in producing a star schema and the type of data they hold.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
A scenario for amount correction & how to use amount correction functionality in AP invoices
Give two examples of how you might determine the structure of the table DEPT.
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
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.
Explain an ORA-01555
What are the mandatory setups in setting up a PO in oracle
What is the use of lockboxes? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Oracle General 
