Re: Store Queries in Oracle

From: TS - Toni Suhartono <toni_s_at_my-dejanews.com>
Date: Fri, 11 Dec 1998 11:40:46 +0700
Message-ID: <3670A24E.5AAFEB13@my-dejanews.com>

Use view instead.
add
"create view <view name> as <your query>"

Satwant Bhumber wrote:

> In Access you can build a query and save it. This query can then be used
> at a later time by just referencing it by name.
>
> But in Oracle I have had to create a new table for the query contents
> and perform an insert query into the table. As a result I have had to
> create an additional 15 tables just for queries which I wanted access.
>
> Surely there has to be a better way?
Received on Thu Dec 10 1998 - 22:40:46 CST