Home » SQL & PL/SQL » SQL & PL/SQL » one question!
one question! [message #213635] Thu, 11 January 2007 10:47 Go to next message
Atif_Khan
Messages: 9
Registered: December 2006
Junior Member
Dear fellows,

As visible by my post no. I am new to Oracle. I have a question that how to list the tables. I ran the command descr but it shows some stuff which I think is other than the tables I have. Anyone here tells me the exact command to see my tables list.

Re: one question! [message #213636 is a reply to message #213635] Thu, 11 January 2007 10:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
-- list the tables
SQL> select * from cat;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
T1                             TABLE
DEPT                           TABLE
EMP                            TABLE
T2                             TABLE
PLAN_TABLE                     TABLE

--describe the tables
SQL> desc dept
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO                                             NUMBER
 DNAME                                              VARCHAR2(14)
 LOC                                                VARCHAR2(13)
Re: one question! [message #213637 is a reply to message #213636] Thu, 11 January 2007 10:55 Go to previous message
Atif_Khan
Messages: 9
Registered: December 2006
Junior Member
Thanks Mahesh for such a quick response. I appreciate that.
Previous Topic: drop column p1 if this exists
Next Topic: Mview with primary key table and no primary key table
Goto Forum:
  


Current Time: Mon Feb 17 22:22:08 CST 2025