what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / sathya
I just wanna add a point ..
while truncating a table both the structure and the datas will be removed. where as in Delete structure of the table ramains only the data in the table will be deleted.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
difference of using cursor for loop and open,fetch,close.which one is better
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What view would you use to determine free space in a tablespace?
Explain the process of recievables in oracle financials. : oracle accounts receivable
how to write customizations in po
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
please send me oracle pl/sql exp resume. and also faqs...
what is difference between inner join & nested query or subqueries
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?