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
What is the disk migration? what is the steps involved in oracle disk migration?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the difference between oracle media recovery and crash recovery?
Can we modify approve purchase order?if yes what is navigation?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
can u give guidance abt packages of plsql
Difference between transaction type and transaction sources. : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
difference of using cursor for loop and open,fetch,close.which one is better
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 is chargeback invoice? How do we create it? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.