| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: Is it possible to drop more than one table using single sql statement? if yes then how.
|
| May 05, 2007 16:17:58 |
#2 |
| abhishek reddy |
Member Since: Visitor Total Comments: N/A |
RE: Is it possible to drop more than one table using s...
|
Yes we can drop more than 1 table using spool.
Dropping all tables from a user:----
sql> select 'drop table' || 'tname' || from tab;
sql> spool pp;
//copy all the data from all the tables//
sql>spool off;
sql> @pp.lst
|
| |
Back To Question | |
