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

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.

2887


How to delete a column in an existing table?

594


What are named parameters?

616


How to filter out duplications in the returning rows using oracle?

641


How to use "for" statements in oracle?

593






How to use subqueries with the in operator using oracle?

612


How to view the data files in the current database?

592


Is oracle an operator?

534


What is a data dictionary and how can it be created?

615


types of indexes and the rationale behind choosing a particular index for a situation.

1985


What are the system predefined user roles?

585


How to define an anonymous block?

618


How to use existing values in update statements using oracle?

545


What are the uses of Database Trigger ?

1101


How can I create database in oracle?

570