Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65457 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / anup.wilson
hii every one ... i want to say that delite is --dml and
truncate is ddl ..nxt thing about roll back ..through
delete we roll back untill unless we are not COMMIT IT..
IF WE COMMIT AFTER DELETE ..WE CANT ROLL BACK IT
...
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What is Restricted Mode of Instance Startup in Oracle?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Give two methods you could use to determine what DDL changes have been made.
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is an Oracle database Full Backup?
What do you mean by Oracle MEDIA RECOVERY?
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?
How would you determine who has added a row to a table?
What is the difference between recovery and restoring of the oracle database?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
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.
8. Supporting AP, AR and GL?
Is there any link between pr form(purchse requisition)and po form(purchase order)
