what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / kotravel. b
TRUNCATE DELETE
1 cannot be 1 can ba RB
roll back
2 faster than 2 slower than truncate
delete
3 it releses the stroge 3 it does not releses the stroge
sp sp
spaces
| Is This Answer Correct ? | 75 Yes | 8 No |
Post New Answer View All Answers
What is Restricted Mode of Instance Startup in Oracle?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
please send me oracle pl/sql exp resume. and also faqs...
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What are different types of transactions in ar? : oracle accounts receivable
8. Supporting AP, AR and GL?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What do you mean by Oracle MEDIA RECOVERY?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
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.
what is difference between inner join & nested query or subqueries