Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL query

Re: SQL query

From: ltiu <ltiu_at_alumni.sfu.ca>
Date: Sat, 13 Jul 2002 07:33:19 -0800
Message-ID: <F001.0049739E.20020713073319@fatcity.com>


select * from dba_cons_columns;

On Saturday 13 July 2002 01:08, Vandana wrote:
> I am sorry for not being precise in my question. I would like to
> view the primary key, foreign key and other 'constraints' information of
> my table. While this could be viewed with 'desc' in other dbmss, this
> information is not provided with the 'desc' in oracle. With what command
> can I view it in Oracle?
>
> On Fri, 12 Jul 2002, Abdul Aleem wrote:
> > At SQL*Plus it is the same command
> > Describe or desc and name of the table
> >
> > You also need to be connected to the database
> >
> > HTH
> > Aleem
> > -----Original Message-----
> > Sent: Saturday, July 13, 2002 11:53 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: SQL query
> >
> >
> > I am using an Oracle database running in Linux. I would like to
> > view the description of a table. For ex., if there is a table called
> > 'person'. I would like to see the names of the columns in this table,
> > their datatypes and such other details. In other dbmss like mysql a
> > command 'describe <tablename>' gives the information. What is the
> > equivalent in Oracle?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: ltiu_at_alumni.sfu.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sat Jul 13 2002 - 10:33:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US