Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> goal_name is different andso is length of string
select of quoted string has different lengths in 2 databases.
DB1 :
SQL> select 'kk' from dual;
'k
-- kk DB2 : SQL> select 'kk' from dual;Received on Fri May 28 2004 - 13:03:18 CDT
'kk'
-------------------------------- kk I tried 3 different Unix server ( sloaris 5.8) and 4 databases of different version ( 8.1.7.4 and 9.2.0.4 -- 2 each) on each server. The only common factor for databases to fall in the group was global_names. DB1 group had global_names = TRUE and DB2 group had global_name = FALSE. Can someone help in understanding why it is so. Or do I have to look something different.....
![]() |
![]() |