extremely useful APEX titbit

This is one of the most useful things I have found while using the SQL Workshop. I am not an oracle expert by any means, and sometimes I find their error messages, for the most part, useless. I discovered something so brainlessly simple it saddens me I didn't think of it myself.

Open the workshop, select 'SQL Commands' and type in the following query:

select * from user_errors;

Save this query with whatever name you want.

Next time you get something really cryptic, like

PL/SQL: Compilation unit analysis terminated

Open the query and run it. It will give you much more useful information.