Re: default column value in view while inserting.

"Rama Shankar" <ramashankar.yadav_at_gmail.com> schreef in bericht news:1163751026.686091.304250_at_j44g2000cwa.googlegroups.com... 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

Why ask for a solution when you don't want to use it? My car doesn't run but I don't want to fill my tank.... ? Received on Fri Nov 17 2006 - 06:47:39 CST