Garayed.com  

Go Back   Garayed.com > Oracle
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-13-2007, 09:27 AM
Bruintje Beer
 
Posts: n/a
Default default values for column

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

thanks a lot

John


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 01-13-2007, 09:36 AM
Thomas Kellerer
 
Posts: n/a
Default 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/c...rt.htm#i125539
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:10 PM.




LinkBacks Enabled by vBSEO 3.0.0 © 2007, Crawlability, Inc.