Re: beginner needs help

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)
>

I would do this

select * from user_catalog

won't give you databases but will give you tables, constraints and things. When you spot a table that looks promising, try

describe table_thingy

for the gore. Received on Tue Jun 29 1999 - 12:26:22 CDT