Re: goal_name is different andso is length of string

MK wrote:

> 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.....

Is see no evidence it is different; all I see are prompts (headers) that differ in length, which may be caused by a combination of settings in the tool you use.
Use indeed the length function, as suggested by Noel

-- 

Regards,
Frank van Bortel