Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: View Related Simple Question !
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
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
![]() |
![]() |