what is the difference between TRUNCATE and DELETE command
in SQL
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 are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
please send me oracle pl/sql exp resume. and also faqs...
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
How would you determine who has added a row to a table?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
How do you create a credit note against an invoice? : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What is autocashrule set? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
What is the sql query to find the employee who has Nth maximum salary?
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?
Give two methods you could use to determine what DDL changes have been made.
what are basic modules required to implement oracle application in any oraganisation?