diff between DELETE and TRUNCATE?.

Answer Posted / dhananjay mukhedkar

The Answer given by Prasad Reddi is perfect.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transport network substrate (tns) in oracle?

577


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1834


What is oracle update statement with inner join ?

569


What is a sub query? Describe its types?

528


How translate command is different from replace?

537






Is truncate autocommit in oracle?

616


How do you store pictures in a database?

546


How a database is related to tablespaces?

568


Can we use bind variables in oracle stored procedure?

474


Explain the use of record length option in exp command.

541


What do you mean by a deadlock?

507


Differentiate between translate and replace?

615


how may join possible between (requisition with purchase order)

1686


Give the different types of rollback segments.

566


what is the difference between functional dependecy and multilevel dependency?

1979