query using column Alias
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
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
0