Re: need information on extracting column names from pro*c

In article <1992May5.183719.21738_at_ms.uky.edu>, skaul_at_ms.uky.edu (Sanjay Kaul) writes:
|> I'm trying to retrieve the table names and field (column) names
|> from within a c program that interfaces to an oracle database.
|>
|> If I have a table name and know nothing else about the table,
|> how can I find out the names and attributes of the columns from
|> within a c program?
|>
|> Thanks in advance!
|> --
|> ***************************************************************
|> Sanjay Kaul * BITNET :cs0768sk_at_ukcc.uky.edu *
|> 700 Woodland Ave, * INTERNET : skaul_at_ms.uky.edu *
|> #E-206,Lexington,KY,40508 * TEL :(606) 258 -6221 *

look in user_tab_columns

while your at it do "select * from tab ;" to see many usefull tables that you can access.

-- 
RICK DIPPER, Unix Systems Administrator                       rick_at_uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............