Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 67148 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 |
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what are the API of GL,PO,AP
wht r the base tables & primary key for BOM& WIP modules
how can it possibble to see the report output in excel sheet in oracle applications
Could you please let me know the interfaces in OM / FA??
can we use lexical perameter in oracle plsql if yes how
What view would you use to look at the size of a data file?
Describe what redo logs are.
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
What is difference b/w Credit memo and Adjustment in AR.
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
Difference between negative and positive adjustments : oracle accounts receivable
Oracle General 
