SQL*Plus (MOSC)

MOSC Banner

query using column Alias

edited May 1, 2013 5:21AM in SQL*Plus (MOSC) 5 commentsAnswered
When i run this query :select 'toto'"TOTO" from dual;

In 10,
==========
[oracle@vslnampro021 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 2 13:06:25 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

SQL> select 'toto'"TOTO" from dual;

TOTO
----
toto

In 11(11.2.0.3),
=============
oracle@vslorasimpers.databases.adehisnet.be:/oracle/admin/logs/prssim>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 2 13:17:08 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
0
SYS@prssim> select 'toto'"TOTO" from dual;
select 'toto'"TOTO" from dual
       *
ERROR at line 1:
ORA-03001: unimplemented feature

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center