RTFM - specifically, that's available in every database but I'm not certain that its standard SQL - I'm using MySQL right now, and the query is "show tables", or you can grab data direct from the internal DB tables but they're very brand-spcific. So get your big book of Oracle knowledge and start digging.