Re: Novice question about table in SQL

Assuming you are using SQL*Plus (a fair bet, based on the examples you gave) then type
SQL> describe cd
This is a SQL*Plus command which gives a quick summary of the column names, data types and NOT NULL constraints. It can be abbreviated to 'desc'.

Martin

jimmy wrote:

>I have installed personal edition of oracle on my computer, I know to
>find all of the tables in my database I use
>select * from tab;
>
>I wish to create a table then add rows to it latter,
>When I use such has
>
>SQL> SELECT * FROM cd ;
>
>I get no rows selected,
>
>How can I get to see the contents of which my table is made up, such
>has my cd table below, if I have not put in any information in to the
>rows of the table , has I may forget how my table is made up
>
>
>CD_NAME CD_ARTIST CD_LABEL
>-------------------- -------------------- --------------------
>
>
>Yours truly,
>James mcgivern
>
>
Received on Mon Oct 28 2002 - 18:42:59 CST