Re: Create View Problem

From: tojo <Tojo_at_hotmail.com>
Date: Thu, 16 Jan 2003 11:42:41 +0100
Message-ID: <MPG.1890ab11cad32ca69896e3@news.t-online.de>

In article <bf7e8fc9.0301160157.18f142e9_at_posting.google.com>, roul_at_gmx.de says...
>
> Thanks Tom, but I wanted to create the view for all products instead
> of one. Your example creates the view for one product. Any help is
> appreciated to solve this.
>
> Ronald
>

I don't get it. Is "sku" your product ID? If so then remove that column from your view as well (so it returns all products) and use sku in the "select * from view":

select *
from (select * from my_view where sku='4711') where rownum = 1

Viele Grüße
Tom Received on Thu Jan 16 2003 - 04:42:41 CST