Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Store Queries in Oracle
On 10-Dez-98 14:25:53 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?
Well, sort of.
Try creating views for your queries. They don't store the uery data just
the SQL but perhaps that is what you want.
Hope that helps,
Lothar
--
Lothar Armbrüster | lothar.armbruester_at_rheingau.netsurf.de Schulstr. 12 | lothar.armbruester_at_t-online.de D-65375 Oestrich-Winkel |Received on Thu Dec 10 1998 - 13:15:22 CST