Fw: Hello World? [2 Attachments]

Toad for Oracle
1

[Attachment(s) from Brian T Keegan included below]

Global warming or column formatting or the emerging world.

select null || ‘hello world’ hello_world from dual;

hello

select null || 'hello world ’ hello_world from dual;

hello w

select null || 'hello world ’ hello_world from dual;

hello wo

select null || 'hello world ’ hello_world from dual;

hello wor

select null || 'hello world ’ hello_world from dual;

hello worl

select null || 'hello world ’ hello_world from dual;

hello world

Hello indeed world,

Brian

“Simoneau, Roger”

         cross.ca> To
         Sent by: "'toad@yahoogroups.com'"
         toad@yahoogroups.
         com cc

                                                               Subject
         09/28/2011 10:58 RE: [toad] Hello World?

Please respond to
toad@yahoogroups.
com

Must be global warming…

2

[Attachment(s) from Brian T Keegan included below]

There’s some sort of wierd formatting going on with the email. In each line
I added 2 more blank spaces to the 'hello world ’

For some reason after I sent the mail you don’t see the added blanks
between world and the single quote.

– Brian

Brian T Keegan

         mersinsurance.com To
         > toad@yahoogroups.com
         Sent by: cc
         toad@yahoogroups.
         com Subject
                                   Fw: [toad] Hello World? [2
                                   Attachments]
         09/29/2011 13:55

Please respond to
toad@yahoogroups.
com

[Attachment(s) from Brian T Keegan included below]

Global warming or column formatting or the emerging world.

select null || ‘hello world’ hello_world from dual;

hello

select null || 'hello world ’ hello_world from dual;

hello w

select null || 'hello world ’ hello_world from dual;

hello wo

select null || 'hello world ’ hello_world from dual;

hello wor

select null || 'hello world ’ hello_world from dual;

hello worl

select null || 'hello world ’ hello_world from dual;

hello world

Hello indeed world,

Brian

“Simoneau, Roger”

cross.ca> To
Sent by: “‘toad@yahoogroups.com’”
toad@yahoogroups.
com cc

Subject
09/28/2011 10:58 RE: [toad] Hello World?

Please respond to
toad@yahoogroups.
com

Must be global warming…

3

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

4

That looks like it’s doing a substr based on the end value.

Here’s a curious question: what do you see when you sneak a peek at what the
query is actually doing?

In case you’re not familiar with it, the installation of Toad comes complete
with a SQL Tracker Utility (great tool). You should be able to find it under
Toad -> Tools in your menu selection. In Toad 10.6.1.3 it’s called “SQL
Tracker”. Once it’s logging against your Toad session, run the query and
take a look at the tracker results to see what was actually sent to the
database.

Roger S.