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

Home -> Community -> Usenet -> c.d.o.server -> goal_name is different andso is length of string

goal_name is different andso is length of string

From: MK <imanoj_at_yahoo.com>
Date: 28 May 2004 11:03:18 -0700
Message-ID: <997a817f.0405281003.4c38f474@posting.google.com>


select of quoted string has different lengths in 2 databases.

DB1 :

SQL> select 'kk' from dual;

'k

--
kk

DB2 :

SQL> select 'kk' from dual;


'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.....
Received on Fri May 28 2004 - 13:03:18 CDT

Original text of this message

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