Re: PL/SQL - does it do all sql statements???????

I too use Unix on a Sun with Oracle.

PL/SQL handles all database DML DDL and DCL statements. SQL*Plus handles quite a bit more.

SELECT columns FROM table;

That in SQL*Plus says to display information ON YOUR SCREEN based on the query results returned. It is invalid inside of PL/SQL because it has no way to talk to your screen. It's running inside of the Oracle RDBMS Kernel which might be halfway around the world.

Ditto - the PROMPT command is part of SQL*Plus, not the SQL Language.

Andy

jrl1_at_kepler.unh.edu (John R Labonte) writes:
> I am using PL/SQL version 1.0.33.1.1 with ORACLE 6.0.33.2.1 and am having
>a problem with some common SQL statements. The manual indicates that
>all sql statements are supported. When I try to use an ordinary select
>statement without doing an "INTO" I get back a parse error. Also the
>PROMPT command doesn't make it through the parse.
>Is it the case that only a subset of SQL is supported when doing PL/SQL?
> John
> University of NH
>PS I am doing this in UNIX on a SUN.
 

-- 
Andrew Finkenstadt  |  andy_at_{homes.com,vistachrome.com,genie.geis.com}
Systems Analyst     |  Vista-Chrome, Homes & Land Publishing Corporation
                    |  1600 Capital Circle SW, Tallahassee Florida 32310
+1 904-575-0189     |  GEnie Postmaster, Unix & Internet RoundTables Sysop