Home » SQL & PL/SQL » SQL & PL/SQL » with clause query (oracle 10g,10.2.0.3, windows 2003 server)
with clause query [message #356685] Sat, 01 November 2008 00:39 Go to next message
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
Re: with clause query [message #356694 is a reply to message #356685] Sat, 01 November 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Also always post your Oracle version (4 decimals).

SQL> WITH q AS (SELECT dummy FROM dual)
  2  SELECT dummy FROM q
  3  /
D
-
X

1 row selected.


Use SQL*Plus and copy and paste the whole session including SQL*Plus header and result of "select * from v$version".

Regards
Michel
Re: with clause query [message #356698 is a reply to message #356685] Sat, 01 November 2008 02:48 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


Same Problem here also

Cool
Rajuvan

Previous Topic: Help!!!!...Error with a Simple Cursor
Next Topic: BULK COLLECT LIMIT generate ORA-01401
Goto Forum:
  


Current Time: Sun Dec 04 22:59:12 CST 2016

Total time taken to generate the page: 0.23100 seconds