Re: DYNAMIC SQL
From: Johannes Reitermayer <h8751814_at_obelix.wu-wien.ac.at>
Date: 1995/07/12
Message-ID: <3u0lnp$h1b_at_osiris.wu-wien.ac.at>#1/1
Date: 1995/07/12
Message-ID: <3u0lnp$h1b_at_osiris.wu-wien.ac.at>#1/1
Shirley <schee_at_rpisun1.mda.uth.tmc.edu> wrote:
>Is it possible to construct a Dynamic SQL (where the number of input to
>the where clause is unknown) strictly using PL/SQL? I
>If this possible, please suggest reference.
Shirley,
the package dbms_sql is your solution:
there is a good article 'dynamic sql comes to pl/sql' in oracle magazine march/april 1995, p.85 explaining what you can do with the package dbms_sql.
oracle ships release 7.1 with a handbook called 'oracle 7 server documentation addendum'. chapter 7 'dynamic sql' explains this package.
hope this helps
Johannes Reitermayer
Software Manufaktur GmbH
2000 Stockerau, Furtmuellerstrasse 3
Austria - Europe
Received on Wed Jul 12 1995 - 00:00:00 CEST