Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66514 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / kavita sahu
1. Truncate is a DDL command and delete is a DML command
2. Truncate delete all records from table there is no
ROLLEDBACK it always Commit without giving the Commit
3. Truncate is much faster than Delete
4. Truncate you can't use where clause
DELETE you can use where clause
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
what is the link between suppliers and banks in ap module in oracle apps? And also query?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
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?
Give two methods you could use to determine what DDL changes have been made.
please send me oracle pl/sql exp resume. and also faqs...
What do you mean by Oracle MEDIA RECOVERY?
What is the importance of batch source set up in ar? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
where the dff data will be stored
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain the use of table functions.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
