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
3. Steps in UAT?
How would you determine who has added a row to a table?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is the sql query to find the employee who has Nth maximum salary?
What are the standard concurent programs for auto invoice interface and customer interfaces? : 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.
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
default triggers available for reports
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
8. Supporting AP, AR and GL?
How to clone the database using RMAN back
as a technical developer in oracle applications which type errors feced in your experience sofar
what ASIS BUSINESS PROCESS IN ORACLE FINANCE