Re: PL/SQL help needed
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sun, 21 Feb 1999 01:37:22 GMT
Message-ID: <mrJz2.6968$yj6.3883_at_news.rdc1.nj.home.com>
Date: Sun, 21 Feb 1999 01:37:22 GMT
Message-ID: <mrJz2.6968$yj6.3883_at_news.rdc1.nj.home.com>
see addendum to 3 below
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Bill Messick wrote in message ...Received on Sun Feb 21 1999 - 02:37:22 CET
>On Fri, 19 Feb 1999 17:13:08 -0800, Farjaad <farjaad_at_yahoo.com> wrote:
>>Hi
>>
>>Could you guys let me have answers to the followings:
>>
>>1. What is the difference between PL/SQL Tables and SQL Tables
>>
>
>PL/SQL tables are data structures like arrays (like "sparse" arrays -- the
>subscripts don't have to be consecutive). You can't use DML (query,
update,
>etc.) on them like SQL tables, and they only exists within one Oracle
>session.
>
>>2. What is Dynamic SQL
>>
>
>That's when you build your SQL statement on the fly in a string, and use
the
>DBMS_SQL package to parse and execute it.
>
>>3. Can we use DDL statments in PL/SQL
>>
>
>Yes, but only if you use dynamic SQL and the DBMS_SQL package to build and
>execute the DDL.
If you are in forms, you can do a forms ddl command.
>
>
>--
>Bill Messick
>Computer Associates Global Professional Services
>