with clause query [message #356685] |
Sat, 01 November 2008 00:39  |
halim
Messages: 100 Registered: September 2008
|
Senior Member |

|
|
hi experts
I have a problem , when i execute the following query
its return the following error ..
is it possible to execute "with clause query" in 10g
Database version is - 10.2.0.3.0
SQL> ed
Wrote file afiedt.buf
1 WITH q AS (SELECT dummy FROM dual)
2* SELECT dummy FROM q
SQL> /
SQL*Plus internal error state 2091, context 0:0:0
Unsafe to proceed
-----------------------------------
when execute in toad-9
it return
SQL statement doesn't return rows
thanks in advance
Halim
|
|
|
|
|