"With statement" don't work

[lav_spb]

For example simple SQL Query:

with c as (select * from dual) select * from c;

in sqlplus return one record, in sql/command window return nothing

Why???

 

[CTzen]

It works fine for me in both SQL & Command windows.

PL/SQL Developer 7.1
Oracle 9i & 10g

 

[Gustavo]

OK here.
Oracle 9.2.0.7
PL/SQL Developer 7.1.1.1347

 

[lav_spb]

PL/SQL Developer 7.03.1123 - Don't work

 

[Theod]

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Developer 7.1.1.1347
=> don't work

 

[Dezsoe Kados]

For me it works in both SQL & Command window:
Oracle Database 10.2.0.2.0 (32 bit)
Oracle client 10.2.0.1.0 (32 bit)
PLSD 7.1.1.1341