Re: beginner needs help

you can query the data dictionary:

SQL> select owner, table_name from all_tables

this shows the table names for all tables you can access in the database. (user_tables shows tables that are owned by you)

the do a desc on the table:

SQL> describe <owner>.<table_name>

To find out all your accessible database is very diffiult, it depends on which system you are, what kind of oracle network you are using and so on...

lasteyrie_at_iname.com wrote:
>
> I'm new to Oracle and i have to use SQL Plus. My problem is
> simple : i have to get informations about tables (how many fields,
> length of each one...), but i don't know the name of my table. can you
> give me the command i have to use to do those things, or if it's not
> possible :
> - list all the databases
> - list tables' names of my databases
> - get tables' fields. (i found describe but i'm not sure)
>
> Thank's for your answer.
Received on Mon Jun 28 1999 - 08:29:58 CDT