what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / bhupat
Truncate Statement:
1.Deletes all the rows from the table.
Delete Statement:
1.Delete a specific row.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to clone the database using RMAN back
Difference between transaction type and transaction sources. : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
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.
as a technical developer in oracle applications which type errors feced in your experience sofar
where the dff data will be stored
What is Restricted Mode of Instance Startup in Oracle?
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.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
What is autocashrule set? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
Are These Dff's Flexible?
Could you please let me know the interfaces in OM / FA??
Difference between negative and positive adjustments : oracle accounts receivable