Re: PL/SQL -- huh?

In article <43mqs0$bsn_at_bull.hkstar.net> Steve Leung <chleung_at_hkstar.com> writes:
>
> >That's funny, I get:
> >SELECT "Output String" FROM DUAL;
> > *
> >ERROR at line 4:
> >ORA-06550: line 4, column 24:
> >PLS-00103: Encountered the symbol "FROM" when expecting one of the following:
> >. ( , * _at_ % & - + / mod rem <an identifier>
> ><a double-quoted string> an exponent (**) into ||
> >Resuming parse at line 4, column 33.
> >
> >
>
> There is a syntax error in the statement, a single quote should be used instead of
> double quote
>
> i.e select 'Output String' From dual;

This still isn't the correct syntax in PL/SQL. In PL/SQL, you have to either SELECT something INTO some variable or declare the select as a cursor. There is no explicit I/O in PL/SQL, though in Oracle7 there is the dbms_output package which handles primitive terminal output.

--
 "Everything that can be said about Win95 has been said... The Win95 user
  interface is not nearly as good as the Mac.  Blah, blah.  It has all been
  said a thousand times." - Larry Ellison

 Alvin W. Law ........................................... Oracle Corporation
 Senior Technical Consultant ................ 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294