UNION ALL: there is restriction for set operators, i.e. the columns in query 1 must match the columns in query2 in data type,order and number.
some e.g.:
display those who are emp as well...
Type: Posts; User: chskumar; Keyword(s):
Re: difference between Union All and full outer join
UNION ALL: there is restriction for set operators, i.e. the columns in query 1 must match the columns in query2 in data type,order and number.
some e.g.:
display those who are emp as well...
truncate does not take any data to the rollback segment or undo tablespace.
truncate is fast.
truncate delete's the data permanently.
delete will copy the data to the undotablespace for...