Search:

hi,
truncate is ddl command and delete is dml command .compare to delete truncate is best in performance bcoz when execute a delete command all record in a table is store into rollback tablespace...

hi,

this is simple question,execute this statement on predefined table in oracle


-->select e.ename employee,m.ename manager from emp e join emp m where
e.mgr=m.empno;