Get default values from OCI [message #199298] |
Mon, 23 October 2006 05:03 |
goodboy
Messages: 1 Registered: October 2006
|
Junior Member |
|
|
Somebody help me!!
I am trying to get the columns which have a default value defined in a table. I am able to get this in SQL by doing a
select * from user_tab_columns where default_length is not null;
However, when i try to describe this view- USER_TAB_COLUMNS from OCI(OCIDescribeAny), I am getting an error. I need to find out the columns that are present in this so that I can dynamically create and keep place holders while binding. how can I describe this user_tab_columns?
Or is there any other way to get the default values for columns in a table?
|
|
|