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

>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?

One way of obtaining column and attribute data is with the following query:

	Select * 
	from user_tab_columns
	where table_name='DESIRED_TABLE';

Good Luck

				|
Stephen P. White		|      [Reserved for future Disclaimers]
Fermilab			|
Batavia, IL			|
-------------------------------------------------------------------------------