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
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
as a technical developer in oracle applications which type errors feced in your experience sofar
How do you create a credit note against an invoice? : oracle accounts receivable
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What view would you use to determine free space in a tablespace?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
1. What is PO rate variance gain and loss?
Are These Dff's Flexible?
What do you mean by hz_ in customer tables? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?