Re: Dynamic Queries using PL/SQL

From: Greg Hoppan <alpha_at_mail.datanet.hu>
Date: 1997/11/20
Message-ID: <3474849B.799A3F4_at_mail.datanet.hu>#1/1

> Hi,
>
> Does anybody have some sample code on how I would go about doing this?
>
> Any help is appreciated!
>
> thanks,
> -talha

Talha,

Dynamic query is available using the DBMS_SQL PL/SQL package. The specification of the package contains a lot of remarks and example code, try to list it. The full code is stored in the SYS.DBA_SOURCE table,
(among many others).

Hope it helps,

G

---

Hoppan Greg Gergely                  WWW  : http://w3.datanet.hu/~alpha/

Managing Director                    Mail : alpha_at_mail.datanet.hu
Alpha Consulting 1996 Limited        Phone: +36-1-351-9020

HUNGARY 1068 Budapest, Benczur u 14 Fax : +36-1-351-9020

---

Received on Thu Nov 20 1997 - 00:00:00 CET