Re: default values for column

Bruintje Beer wrote on 13.01.2007 11:27:
> Hi,
>
> I want to get the default values for table columns using occi. How can I do
> that. I think I have to read the meta data but can not find out what
> attribute I need to get the default value for colns. Can somebody point me
> to an url or give me an example how to that in occi en c++

SELECT column_name, data_default
FROM all_tab_columns
WHERE owner = 'ME'
AND table_name 'THE_TABLE'

More details at:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_part.htm#i125539 Received on Sat Jan 13 2007 - 04:36:53 CST