Tip: Drop All Tables/Sequences from a User

I was testing a deployment script today and after about 10 tables something would fail. And it took a few goes to get it right (silly leading spaces). So I was getting very frustrated manually dropping all tables and constraints I had just built. So I did a bit of digging and came across this: select ‘DROP TABLE [SCHEMA_NAME].’ || TABLE_NAME || ‘ CASCADE CONSTRAINTS;’ … Continue reading Tip: Drop All Tables/Sequences from a User

Application Express Views (5.0.4)

There are a huge amount of background tables and views in Oracle’s APEX, and a lot of them are very useful, but hard to find. Below is an excel spreadsheet of all the views that I’ve gathered from other people, with a brief explanation of their purpose. I only know these to be accurate up to APEX 5.0.4, as these views may or may not … Continue reading Application Express Views (5.0.4)