By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

get default funtion of a column

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
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

Jul 19 '05 #3

P: n/a
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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.