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

Dynamic APEX Logo

I was tasked with creating a dynamic logo for our APEX site. The application was branded in different ways and it didn’t look quite right having a “LOGO” written there, and adding another image was a bit overkill. So instead we wanted to have “Hi Employee!” as the logo whenever someone logged in. Normally a nice and easy thing to do anywhere else on an … Continue reading Dynamic APEX Logo