what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / praveena
Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so
| Is This Answer Correct ? | 13 Yes | 43 No |
Post New Answer View All Answers
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
which one is currently in used software cmpanies.
Can we modify approve purchase order?if yes what is navigation?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
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
Why more redos are generated when the oracle database is in begin backup mode?
What is the mandatory setup in cyclecount ?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..