Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novice question about table in SQL
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
If you type the following, you'll see your table definition as it
appears in the data dictionary:
DESCRIBE cd
The DESCRIBE command (abbrev: DESC) is case-insensitive Received on Mon Oct 28 2002 - 18:24:26 CST