Re: PL/SQL help needed

From: Stephen E. Kraus <skraus_at_cisco.com>
Date: Fri, 19 Feb 1999 17:09:33 -0800
Message-ID: <36CE0B4D.6CCE@cisco.com>

1. PL/SQL tables are memory resident, regular (SQL?) tables are stored on disk. Regular tables are more permanent and can be much larger.
2. Dynamic SQL is SQL that can be built up in a program, often done via dbms_sql package. See 3 below.
3. Yes, DDL can be done. See $ORACLE_HOME/rdbms/admin/dbmssql.sql for package dbms_sql.

Farjaad wrote:
>
> Hi
>
> Could you guys let me have answers to the followings:
>
> 1. What is the difference between PL/SQL Tables and SQL Tables
>
> 2. What is Dynamic SQL
>
> 3. Can we use DDL statments in PL/SQL
>
> Your kind help would be much appreciated
>
> Thanks
> Farjaad
> farjaad_at_yahoo.com

--

---

Stephen Kraus                           Cisco Systems, Inc.
Senior Database Administrator           170 West Tasman Drive
Database Administration                 San Jose, CA 95134-1706
Information Services                    United States

Customer Advocacy
SJ - K1, A5-5

                                             |||          |||
Voice    : +1 (408) 527 - 9301              |||||        |||||
Fax      : +1 (408) 527 - 6110             |||||||      |||||||
E-mail   : skraus_at_cisco.com               |||||||||    |||||||||
Pager    : (408) 814 - 8618              |||||||||||  |||||||||||   
 (alpha)   skraus_at_epage.cisco.com       ||||||||||||||||||||||||||
Cellular : (408) 218 - 7278            ||||||||||||||||||||||||||||

=====================================================================

Received on Fri Feb 19 1999 - 19:09:33 CST