Re: get default funtion of a column

yliu_at_tibco.com (Ye Liu) wrote in message news:<617c9c4b.0312171351.1d89db7_at_posting.google.com>...
> create table t1(col1 number getnumber()) // getnumber is a funtion to
> generate default value of col1.
>
> How I can get this function string by a query on data dictionary
> views?

I'm not perfectly certain that I understand your question correctly, but here goes anyway.

If you are trying to get to see the code for that function to see what it does, you may find it in the DBA_SOURCE view. The statement below work for me to get the code for one of my functions:

select line

      , substr(text,1,100) as SourceCode  from dba_source
where owner = 'BBC'
 and name = 'XKLUB'
order by line asc;

Hope this helps.

Bo Brunsgaard Received on Thu Dec 18 2003 - 10:27:08 CET