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

Can we call procedure inside function in oracle?

619


What is a directory object?

599


What is catalog in Oracle?

665


Please explain compound trigger in oracle?

607


Is oracle the best database?

526






How to use in conditions in oracle?

569


Is java required for oracle client?

556


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1512


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1596


How to rename an index in oracle?

626


How to create additional tablespaces for an new database?

581


What is the data pump export utility?

654


Explain the truncate in oracle?

555


How to connect the oracle server as sysdba?

640


Is there an oracle sql query that aggregates multiple rows into one row?

554