Home » SQL & PL/SQL » SQL & PL/SQL » Retrieving data about a table (e.g., column names)
Retrieving data about a table (e.g., column names) [message #7040] Fri, 16 May 2003 19:12 Go to next message
Joe Cohen
Messages: 3
Registered: May 2003
Junior Member
I've got a 'table name'. Is there an API (OCI) to say something like: please return me the names of the columns in this table ?
Re: Retrieving data about a table (e.g., column names) [message #7042 is a reply to message #7040] Sat, 17 May 2003 03:29 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
DESCRIBE &your_table
--
or:
--
SELECT column_name
FROM all_tab_columns
WHERE table_name = UPPER ('&your_table');
Re: Retrieving data about a table (e.g., column names) [message #7057 is a reply to message #7040] Mon, 19 May 2003 02:08 Go to previous messageGo to next message
Gilbey
Messages: 87
Registered: March 2002
Member
Use this..

SQL> desc user_tab_columns;
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------------------
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 COLUMN_NAME                               NOT NULL VARCHAR2(30)
 DATA_TYPE                                          VARCHAR2(106)
 DATA_TYPE_MOD                                      VARCHAR2(3)
 DATA_TYPE_OWNER                                    VARCHAR2(30)
 DATA_LENGTH                               NOT NULL NUMBER
 DATA_PRECISION                                     NUMBER
 DATA_SCALE                                         NUMBER
 NULLABLE                                           VARCHAR2(1)
 COLUMN_ID                                 NOT NULL NUMBER
 DEFAULT_LENGTH                                     NUMBER
 DATA_DEFAULT                                       LONG
 NUM_DISTINCT                                       NUMBER
 LOW_VALUE                                          RAW(32)
 HIGH_VALUE                                         RAW(32)
 DENSITY                                            NUMBER
 NUM_NULLS                                          NUMBER
 NUM_BUCKETS                                        NUMBER
 LAST_ANALYZED                                      DATE
 SAMPLE_SIZE                                        NUMBER
 CHARACTER_SET_NAME                                 VARCHAR2(44)
 CHAR_COL_DECL_LENGTH                               NUMBER
 GLOBAL_STATS                                       VARCHAR2(3)
 USER_STATS                                         VARCHAR2(3)
 AVG_COL_LEN                                        NUMBER

SQL> select COLUMN_NAME from user_tab_columns
  2  where table_name='TEMP';

COLUMN_NAME
-------------------------------------------------------------------------------
SNO
AMOUNT

Gilbey

Re: Retrieving data about a table (e.g., column names) [message #7117 is a reply to message #7042] Wed, 21 May 2003 15:30 Go to previous message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
Barbara : Right on the head. Your 'select' does it wonderfully. Thanks.....Joe
Previous Topic: Missing Expression Error
Next Topic: Help with DECODE
Goto Forum:
  


Current Time: Tue Apr 23 11:39:35 CDT 2024