How many values can a IN operator contain in oracle 9i ..i mean if i have a query saying emp_no in (100,200,300,400 etc etc)..what is the maximum number of values that the IN operator allows?Thanks for your time ..
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …