what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / sathya
I just wanna add a point ..
while truncating a table both the structure and the datas will be removed. where as in Delete structure of the table ramains only the data in the table will be deleted.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between transaction type and transaction sources. : oracle accounts receivable
What is supporting issues GL AP and AR?
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.
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
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
How would you determine who has added a row to a table?
What is Tax Categories?
HOW TO SPOT AHIERARCHY?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what is semphore explian it?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
How do you create a credit note against an invoice? : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count