diff between DELETE and TRUNCATE?.

Answer Posted / shilpa.oracle

Answer given by Manoj is Absolutely correct.

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 a Nested Loop join?

1560


How to apply filtering criteria at group level in oracle?

574


How to insert a new row into a table in oracle?

577


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3857


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2052






Can we use bind variables in oracle stored procedure?

480


How to convert times to characters in oracle?

595


How to do a full database export?

627


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2879


How to retrieve data from an explicit cursor?

553


if you ctreate table identity

1836


How to export your own schema?

558


How to view the tablespaces in the current database?

548


How will you differentiate between varchar & varchar2?

581


Why does oracle 9i treat an empty string as null?

530