Amit

• Aug 28th, 2016

Adding 2 cents 1) DELETE is DML command because it does not change data dictionary (Every command which changes data dictionary tables is called DDL command ) TRUNCATE is DDL command is changes stor...

Ashakant Kendre

• May 9th, 2016

1>TRUNCATE is a DDL command whereas DELETE is a DML command. 2>TRUNCATE is much faster than DELETE. Reason: When you type DELETE. All the data get copied into the Rollback Tablespace first, then del...

Answer Question  Select Best Answer

raman sharma

• Mar 2nd, 2012

There are two type of join

1)inner join
inner join have a three type
I)equi join
II)nonequi join
III)self join

and outer join have a two type

I)right outer join
II)left outer join

and one is a ANSI join that a advance

Pradeep

• Feb 21st, 2012

Join, Inner join, Outer join, Left join, Right join, Full join

Answer Question  Select Best Answer