what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / guest
Truncate command cannot be rolled back while Delete can be
| Is This Answer Correct ? | 178 Yes | 18 No |
Post New Answer View All Answers
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
How would you go about increasing the buffer cache hit ratio?
Where in the Oracle directory tree structure are audit traces placed?
What is mrc and what is its use? : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
as a technical developer in oracle applications which type errors feced in your experience sofar
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
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?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
3. Steps in UAT?
8. Supporting AP, AR and GL?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?