Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: View Related Simple Question !

Re: View Related Simple Question !

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/10
Message-ID: <952672514.8930.1.pluto.d4ee154e@news.demon.nl>#1/1

Sorry to say so, but you don't seem to understand the view concept.. A view is a filter on one or more tables, so there is simply no data in a view that doesn't exist in the underlying table. You need to modify the view, not insert in it.

Hth,
Sybrand Bakker, Oracle DBA

  Parvinder Singh <parora_at_questone.com> wrote in message news:38C88FEA.D3BC1940_at_questone.com...
  Hi all
   I have created a view like this

  system_at_SUN> create view pdv as
    2 select pd id from product where pd id = 'PROD00001' and   pd hierarchy = 'STANDARD';

  View created.

  system_at_SUN> select * from pdv;

  PD ID



  PROD00001        Now i want to include some more values in the view like for 'PROD00002'
  and 'PROD00003' . Insert clause wont work coz these values are already

  present in the product table ... how do i include them in the view ????

  Thanks & Regards
  ~Parvinder

  P.S : Also reply to parora_at_questone.com

--
Received on Fri Mar 10 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US