Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 67145 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / chandu
Delete:
In delete statement we can use conditions
we can roll back
we can delete parent and child table rows also
it will activate in triggers
it can be slow compare to truncate.
Truncate:
In truncate statement we cant use conditons.
we cant roll back
we can delete child table rows only.
it will not activate in triggers.
it can be fast compare to delete.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
can u give guidance abt packages of plsql
What is supporting issues GL AP and AR?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
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.
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.
where the dff data will be stored
Explain prerequisites and post activities of oracle database installation
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what are basic modules required to implement oracle application in any oraganisation?
default triggers available for reports
