Oracle9i Enterprise Edition Release 9.0.1.1.1
Returns the same result "axdef"
"Peter Yu" <yuyh_at_sp.edu.sg> wrote in message
news:3c96d746$1_at_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 - 08:40:49 CST
