Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65593 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amit
In Truncate only data are remove from table
where as in delete structure of table are delete.
| Is This Answer Correct ? | 3 Yes | 9 No |
Answer / 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 |
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
default triggers available for reports
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is Restricted Mode of Instance Startup in Oracle?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
types of receipts and detail desription about recipts and tables effected by receipts?
Describe the P2P cycle ?
Can We Restore a Table that accidantly dropped.
Explain the process of recievables in oracle financials. : oracle accounts receivable
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
What command would you use to encrypt a PL/SQL application?
Oracle General 
