Re: Dynamic SQL in PL/SQL

Ku Kam Ming (kmku_at_hkusua.hku.hk) wrote:

: Where and how I can get info. of using dynamic SQL in PL/SQL?
: BTW, I found that there are PL/SQL package dbms_sql which can execute
: dynamic SQL, which manuals mention those packageS???
 

: Thanks,
: --
: **********************************************************************
: Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
: Assistant Computer Officer
: Main Library, Email : kmku_at_hkucc.hku.hk
: The University of Hong Kong, Tel. : (852) 2859-8068
: Pokfulam Road, Hong Kong. Fax. : (852) 2858-9420
: *********************************************************************
:

--
Oracle supplies a full description of each of the routines in the DBMS_SQL
package in "Oracle Server Documentation Release 7.1 - Chapter 7 Dynamic SQL".
It's another really good Oracle manual.

Have fun, we use it a lot.


PGY  (Opinions expressed are mine and mine alone)
################################################################
#  Paul Young                                                  #
#  youngpa_at_statcan.ca                                          #
#  Statistics Canada                                           #
################################################################