APEX: Inline Error with Client-Side Validation (w/ Validating Number)

We had an issue raised where a user wasn’t happy that the validation was happening on submit, requiring them to spend time filling out several more details before being told they made a mistake. Specifically the fields being submitted were all number fields, and as such we only want valid numbers in there. After some Googling, I thought I’d combine what I’ve learnt on my … Continue reading APEX: Inline Error with Client-Side Validation (w/ Validating Number)

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