Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Bug in PL/SQL ?

Bug in PL/SQL ?

From: Peter Yu <yuyh_at_sp.edu.sg>
Date: Tue, 19 Mar 2002 14:14:27 +0800
Message-ID: <3c96d746$1@sspwb100.sp.edu.sg>


Try this in sqlplus:

variable xxx varchar2(9)

select translate(translate('321xabcdef','123abc','a'),'b','b') from dual; exec :xxx := translate(translate('321xabcdef','123abc','a'),'b','b'); print xxx

The above give 2 different results:

axdef for SQL select

xdef for PL/SQL

Is this a bug ??? Received on Tue Mar 19 2002 - 00:14:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US