Answer / muralipitti

Delete - temparaly delete the table we can undo it using
rollback where as

truncate= delete+commit we can't rollback it .

Answer / udhayakumar

delete is used to delete one or more rows from the table
where as truncate to delete all the rows without its
structure from the table

Answer / nandini sett

Both delete and Trunate are DML or Data Manupilating
Language.
Both statements --- Delete table_name and Truncate table
table_name --- deletes all rows.
Truncate Table works faster than delete.
Truncate table does not support where clause and truncate
doe not fire a trigger. When truncate is used the deleted
rows are not entered in transaction log.

Answer / rajesh

Delete is DML statement which can delete data from table
which needs to be commited afterwards. But it doesn't free
memory area occupied by the data in the table.Where clause
can be used.

Truncate is DDL statement which is auto commit. It not only
deletes all data from table, but it also frees the memory
area occupied the data in the table. where clause is not
permitted. Works faster than delete statement

Answer / shivaindu

Differentiate between TRUNCATE and DELETE:
-----------------------------------------
TRUNCATE deletes much faster than DELETE
TRUNCATE HAS NO CONDITION CLAUSE. WHERE AS DELETE HAS CONDITION.

Delete
~~~~~~
1> Executes triggers
2> DML statement
3> Roll back possible
4> Flash query can get the data
5> cannot free the table free space

Truncate
~~~~~~~~
1>No trigger Execution
2>DDL statement
3>No roll back possible
4>can’t get data from flash queries
5>Option to free table space

Answer / chandrakala

also delete is a DML statement where as truncate is a DDL
statement.

Answer / shankar

DELETE and TRUNCATE both delete table from database, but

DELETE - temperorily deletes the table so we can undo the
table.

TRUNCATE - Perminently delete the table from database so we
cant undo it.

Answer / kiran.

Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.

Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;

Answer / joe

Delete is DML and truncate is DDl;
both or used to delete the records from the table.

We can rollback the deleted records but we cant when we used truncate.

Delete is faster than truncate

Why use truncate instead of delete?

0 Answers  

Why we use cross join?

0 Answers  

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

What if we write return in procedure?

0 Answers  

What is multiple columns?

0 Answers  

Talk about views

10 Answers   Polaris,

How do I run a pl sql procedure in sql developer?

0 Answers  

What is number function in sql?

0 Answers  

Is join an inner join?

0 Answers  

What is the life of an sql statement?

0 Answers