Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66487 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / chandu
Delete:
In delete statement we can use conditions
we can roll back
we can delete parent and child table rows also
it will activate in triggers
it can be slow compare to truncate.
Truncate:
In truncate statement we cant use conditons.
we cant roll back
we can delete child table rows only.
it will not activate in triggers.
it can be fast compare to delete.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
as a technical developer in oracle applications which type errors feced in your experience sofar
What view would you use to determine free space in a tablespace?
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.
How to clone the database using RMAN back
Explain the process of recievables in oracle financials. : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
How many segment are present in Oracle Manufacturing
Is there any link between pr form(purchse requisition)and po form(purchase order)
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the sql query to find the employee who has Nth maximum salary?
