oracle: select * from tab for other types?
Yes, there are (ALL_OBJECTS, ALL_TABLES, ALL_SEQUENCES, ...)
All of them are documented in the manual:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm
Yes, there are (ALL_OBJECTS, ALL_TABLES, ALL_SEQUENCES, ...)
All of them are documented in the manual:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm