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...
Type: Posts; User: imtiazali; Keyword(s):
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;