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]

Re: get default funtion of a column

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



yliu@tibco.com (Ye Liu) wrote in message news:<617c9c4b. 0312171351.1d89 db7@posting.goo gle.com>...

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