Deleting all existing tables from a schema in Oracle APEX

BEGIN
FOR c IN (SELECT table_name FROM user_tables) LOOP
EXECUTE IMMEDIATE ('DROP TABLE "' || c.table_name || '" CASCADE CONSTRAINTS');
END LOOP;
END;

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

The process of building a dashboard and developer documentation portal from scratch

OpenCV Rave: Make Color Changing GIFs (and Memes) using Python & OpenCV

Mistakes I made this year new S

My Take Towards CKA & CKAD + September Curriculum Update Tips

Amazon Campus Online Test Questions

12 Tool Online Help You Write CSS More Easily

Easy fix for VCRUNTIME140_1.dll was not found

Automating code review on commit

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
SuperChai

SuperChai

More from Medium

Introduction to Clustering Methods

How do we know what we know?

Global And Local Variables

Be resourceful…Create your own paths for success!!!