Re: 9.2.0.5 SQL-s converted to UPPER case & comments are truncated.

From: <J.Velikanovs_at_alise.lv>
Date: Thu, 8 Jul 2004 19:19:59 +0300
Message-ID: <OF66622077.72FF04CA-ONC2256ECB.0059B1F0-C2256ECB.005A6A0D@alise.lv>

And in 10g.
BANNER

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL Version 10.1.0.2.0 - Production

SYSTEM:gonza> @bu

no rows selected

SYSTEM:gonza> declare v_n number;
SYSTEM:gonza> begin
SYSTEM:gonza> select /* Please don't take this comment away ;) */ count(*)

into v_n from Dual where 0=4;
SYSTEM:gonza> end;
SYSTEM:gonza> /

PL/SQL procedure successfully completed.

SYSTEM:gonza> @bu

EXECUTIONS HASH_VALUE
---------- ----------

SQL_TEXT

1 1469127923
SELECT COUNT(*) FROM DUAL WHERE 0=4

SYSTEM:gonza> set feed on
SYSTEM:gonza> declare v_n number;
SYSTEM:gonza> begin
SYSTEM:gonza> SeLeCt /* YOU CAN WRITE SQL IN ANY CASE YOU'LL GET THE SAME

;) */ count(*) into v_n from Dual where 0=4; SYSTEM:gonza> end;
SYSTEM:gonza> /

PL/SQL procedure successfully completed.

SYSTEM:gonza> @bu

EXECUTIONS HASH_VALUE
---------- ----------

SQL_TEXT

2 1469127923
SELECT COUNT(*) FROM DUAL WHERE 0=4 1 row selected.

SYSTEM:gonza> declare v_n number;
SYSTEM:gonza> begin
SYSTEM:gonza> select /*+ Please don't take this comment away ;) */

count(*) into v_n from Dual where 0=4;
SYSTEM:gonza> end;
SYSTEM:gonza> /

PL/SQL procedure successfully completed.

SYSTEM:gonza> @bu

EXECUTIONS HASH_VALUE
---------- ----------

SQL_TEXT

2 1469127923
SELECT COUNT(*) FROM DUAL WHERE 0=4 1 695194161
SELECT /*+ Please don't take this comment away ;) */ COUNT(*) FROM DUAL WHERE 0=4 2 rows selected.

SYSTEM:gonza> sElEcT /* For NON-REC SQL case is still IMPORTANT */ count(*) FROM DUAL WHERE 0=4;

COUNT(*)

1 row selected.

SYSTEM:gonza> @bu

EXECUTIONS HASH_VALUE
---------- ----------

SQL_TEXT

         2 1469127923
SELECT COUNT(*) FROM DUAL WHERE 0=4          1 2902315385
sElEcT /* For NON-REC SQL case is still IMPORTANT */ count(*) FROM DUAL WHERE 0=4          1 695194161
SELECT /*+ Please don't take this comment away ;) */ COUNT(*) FROM DUAL WHERE 0=4 3 rows selected.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Jul 08 2004 - 11:24:10 CDT