Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Bug in PL/SQL ?
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
![]() |
![]() |