Answer / shilpa

Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination

Answer / debi

1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate

Answer / raam

Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.

ramumcato@yahoo.com

Answer / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Answer / amol

Be very careful when deleting records. You cannot undo this
statement! but in mysql...

How do I make my sql query run faster?

0 Answers  

How does one load ebcdic data? : aql loader

0 Answers  

What is a constraint? Tell me about its various levels.

0 Answers  

How do I view a sql trace file?

0 Answers  

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

How do temporal tables work?

0 Answers  

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

What is sql and how does it work?

0 Answers  

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

what is view? : Sql dba

0 Answers  

How to process query result in pl/sql?

0 Answers  

what is oltp (online transaction processing)? : Sql dba

0 Answers