Home » Developer & Programmer » Precompilers, OCI & OCCI » Get default values from OCI
Get default values from OCI [message #199298] Mon, 23 October 2006 05:03
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?
Next Topic: Connect in Unicode mode
Goto Forum:

Current Time: Fri Aug 18 01:40:50 CDT 2017

Total time taken to generate the page: 0.08541 seconds