Originally posted by zkajfez
I need select from data dictionary,I mean selects I can see
for example all tables in my db.
Thanks for advice,Zvonimir
There are lots of views on the Oracle data dictionary to do this. The ones starting with USER_ show just objects you own, views starting ALL_ show all objects you can see, and DBA_ show all objects in the database.
For example, USER_TABLES has a row for each of your tables, USER_TAB_COLUMNS describes the columns of your tables...