HOW TO DROP ALL TABLES WITH THEIR CONSTRAINTS AT ONCE IN ORACLE 1

HOW TO DROP ALL TABLES WITH THEIR CONSTRAINTS AT ONCE IN ORACLE

elect 'drop table ', table_name, 'cascade constraints;' from user_tables;

Here is what the above code is Doing:
1. It’s creating a cursor object.
2. It’s executing the SQL query.
3. It’s fetching the result of the SQL query.
4. It’s printing the result.

Similar Posts