get default funtion of a column

[Ye Liu]

Hi, Folks.

If I have table

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?

Thanks,

--ye

[FaheemRao]

do you mean that how you can get return value in data dictionary view
?

I think this function will be executed on fly if you are trying to
insert in this table.
Faheem

yl**@tibco.com (Ye Liu) wrote in message news:<61*************************@posting.google.c om>...

Hi, Folks.

If I have table

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?

Thanks,

--ye

[FaheemRao]

do you mean that how you can get return value in data dictionary view
?

I think this function will be executed on fly if you are trying to
insert in this table.
Faheem

yl**@tibco.com (Ye Liu) wrote in message news:<61*************************@posting.google.c om>...

Hi, Folks.

If I have table

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?

Thanks,

--ye

[Bo Brunsgaard]

yl**@tibco.com (Ye Liu) wrote in message news:<61*************************@posting.google.c om>...

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