Am I imagining things?

Anyone here with 9.0.1.1 for NT installed on W2K?

Please do the following:

Go to SQL*Plus and type:
set pause on pause 'Press Return to continue...' then do:
select * from dual;

Tell me what happens to your session.

Mine vanishes. In three boxes now. All Win2K Pro, all 9i default install, all P4s.
WTF? Also, a bone to pick ewith Mr. Oracle:

We were told that SQL and PL/SQL now had the same parser.

OK, says I: I can now use SQL conditions in my PL/SQL IF statement. So I go to SQL manual and check out what are all possible conditions. Then I try in a PL/SQL block:

if (colmna in ('A','B','C') then
etc,etc.
It works. It also worked in 8i.

if (colmna like 'A%') then
etc,etc.
It works. It also worked in 8i.

if (exists (select 1 from dual)) then
etc,etc.
Bang, goes the syntax checker. Also in 8i, of course.

So, when is a SQL condition not parsed the same in PL/SQL?

Hmmmmmmm?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Apr 11 2002 - 06:26:25 CDT