WITH Clause [message #302773] |
Wed, 27 February 2008 00:24  |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
This query return error,
SQL> with data as (select * from emp) select * from data;
unknown command beginning "with data ..." - rest of line ignored.
What's problem? Can we use WITH Clause? Any version Problem?
Thanks
Mano
|
|
|
|
|
|
|
|
|
Re: WITH Clause [message #302830 is a reply to message #302773] |
Wed, 27 February 2008 02:14   |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for Linux: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
|
|
|
|
Re: WITH Clause [message #302838 is a reply to message #302773] |
Wed, 27 February 2008 02:32   |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Feb 27 14:02:33 2008
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
|
|
|
|
|
|
|
|
Re: WITH Clause [message #302851 is a reply to message #302846] |
Wed, 27 February 2008 03:09   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Since sqlplus has a set of its own commands, it first tries to interpret what you enter.
This means, that it must be able to recognize SQL as being SQL.
Since WITH ... was not valid SQL in 8.0.6, sqlplus does not recognize your query as being SQL.
So: upgrade your client.
|
|
|
|
|
Re: Should I stay or should I go? [message #302953 is a reply to message #302930] |
Wed, 27 February 2008 07:25   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Littlefoot wrote on Wed, 27 February 2008 13:45 | spmano1983 wrote on Wed, 27 February 2008 09:33 | what i should do?
|
Something like this:
....
|
No!
Upgrade your client along with your server!
|
|
|
Re: WITH Clause [message #302962 is a reply to message #302838] |
Wed, 27 February 2008 07:50  |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
spmano1983 wrote on Wed, 27 February 2008 03:32 | SQL*Plus: Release 8.0.6.0.0 - Production on Wed Feb 27 14:02:33 2008
(c) Copyright 1999 Oracle Corporation. All rights reserved.
|
Just to let you know, this version isn't even 8i, it's 8.0, which was desupported on 30 Sep 2001.
|
|
|