Re: beginner needs help

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Mon, 28 Jun 1999 14:40:26 +0100
Message-ID: <377778ef.0@145.227.194.253>

> - list all the databases

pass on this one

> - list tables' names of my databases

This can be found by doing

    select table_name
    from user_tables;

user_tables contain all tables in your schema, all_tables show all tables in your schema and the ones you have been granted access to and dba_tables show everything (if you have dba rights).

> - get tables' fields. (i found describe but i'm not sure)

Try

    select column_name,

            data_type,
            decode(nullable, 'Y', null, 'Not Null') "Null?"

    from user_tab_columns
    where table_name = <your_table_name>;

Mark

lasteyrie_at_iname.com wrote in message
<37776cd6.4128395338_at_news.univ-angers.fr>...
> 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:40:26 CDT