Re: "Create Table" in Stored Procedure

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/11/07
Message-ID: <47nqdj$2qv_at_ixnews7.ix.netcom.com>#1/1


alaw_at_us.oracle.com (Alvin W. Law) wrote:

>If you are running RDBMS version 7.1.X, you can use the package
>DBMS_SQL to issue DDL statements, such as create/drop
>tables/views/indexes, truncate tables, etc.
 

>I don't know where you can find documentation, but the source itself
>($ORACLE_HOME/rdbms/admin/dbmssql.sql) does contain decent comment on
>how to use each and every function/procedure within the package.

The 7.1 addendum manual documents dynamic sql in chapter 7.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!
Received on Tue Nov 07 1995 - 00:00:00 CET

Original text of this message