Re: View Related Simple Question !

Look the problem is that in one breath you talk about wanting to 'add' to a view which most people would take to mean, increasinh the resultset that you would get if you selected all the tuples of the view.

Then in the next breath you are using the word 'INSERT' which is a DATA MANIPULATION LANGUAGE (DML) procedure, not a DATA SELECTION procedure.

So re-define your terms and restate exactly what it is you are trying to do and then maybe someone can help.

Parvinder Singh wrote:
>
>
>
> Sybrand Bakker wrote:
>
> 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.
>
>
> Even i know that view is a filter on the table and if i
> delete the records from the view its gonna delete from the
> table too ....Its just a matter of words Sybrand to put in
> the problem thats why i clearly gave the example too as to
> what i want ....probabaly i should have written that
> statement something like this "I want to expand my view's
> filter " then would have been fine i guess right ??? Giving
> example is the best rather than focusing on the statement of
> the problem ...thats what i feel ??
>
>
> You need to modify the view, not insert in it.
> how ??? using the alter view command which only compiles the
> view for its validity ...or u man to say that i should again
> recreate the view with the new query ??
>
> regards
> ~Parvinder
>
>
>
>
> 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
>
> Name: parora.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Parvinder Singh
Received on Fri Mar 17 2000 - 00:00:00 CST