How to list APEX Dictionary views using SQL

Hi, I hope this isn't old news but it seems that whenever someone talks about the APEX dictionary they talk about going into the development application and viewing them there. You can also access the dictionary using SQL. Here's how: select * from ...