Re: Fw: Hello World?

Hey Brian,

[snip]

> select null || 'hello world        ' hello_world from dual;
>
> hello worl
>
> select null || 'hello world          ' hello_world from dual;
>
> hello world

It's just because you see the email/post as HTML, which may compress the
multiple spaces.  When converted to plain text, they're there.  In any case:

1)  What's the DB character set from V$NLS_PARAMETERS?

2)  The NULL is not the same as CHR(0) -- it does not have a length.  Do you
see differences in the above if you wrap the NULL||'...' in a DUMP()
function?

Let us know, let us know, let us know!

Rich -- [TeamT]

Disclaimer:  And since we've no place to go...



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/