Re: default column value in view while inserting.

Hi,
thanks for your suggetion.

That can be done using instead of trigger .. Bue I dont want to use any trigger....

is there any way to define default value in view as we define in table ...

hansijie_at_citiz.net wrote:
> To my opinion , you should use trigger to meet your requirement.
>
> "Rama Shankar дµÀ£º
> "
> > Hi all,
> > I have a table like
> > create table rs_temp (nm varchar2(10), id number, code number)
> >
> > and a view like
> > create or replace view rs_vw_1 as
> > select nm,id from rs_temp where code =1
> >
> > Is there any way that whenever we insert into the view it insert CODE
> > =1 in base table
> >
> > eg-
> >
> > insert into rs_vw_1 values ('a',101);
> >
> > and in base table the record should go as
> >
> > 'a', 101 , 1
> >
> > Thanks in advance
> > regards
> > -rama
Received on Fri Nov 17 2006 - 02:10:26 CST