Re: INSERT with WHERE???

Hi,

Could you illustrate the below by some example? INSERT
 WHEN (<condition>) THEN
   INTO <table_name> (<column_list>)
   VALUES (<values_list>);

-ASK vnr1995_at_gmail.com wrote:
> How about
>
> INSERT
> WHEN (<condition>) THEN
> INTO <table_name> (<column_list>)
> VALUES (<values_list>);
>
>
>
>
> sethukr_at_gmail.com wrote:
> > hi everybody,
> >
> > Hope i'm in the right group.
> > If not, please forgive me.
> > I'm very much screwed by INSERT clause.
> >
> > Is it possible to use INSERT with WHERE condition??
> >
> > Can anybody explain me with an example.
> >
> > Thanks in advance,
> > Sethu.
Received on Tue Dec 12 2006 - 10:49:25 CST