Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a user defined function as default value for a column

826439Jan 16 2012 — edited Jan 16 2012
Hi All

Can we call a user defined function as default value for a column ??

for example:
create or replace  function test1  return number is
begin 
return 10;
end;


create table testt
 (id  as test1,
  name varchar2(20));


getting error:

Error at line 1
ORA-02000: missing ( keyword
Thanks
Ashwani

Edited by: Ashwani on Jan 16, 2012 1:19 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2012
Added on Jan 16 2012
1 comment
123 views