Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] Porting SQL to Oracle
Sorry. That should have been off of TurkBear's portion of the thread....
Oops,Brian
Brian Peasland wrote:
>
> Didn't we have a president that tried to tell us what the definition of
> is is?
>
> Cheers,
> Brian
>
> Billy Verreynne wrote:
> >
> > Daniel Zuppinger wrote:
> >
> > > select x,x,z from tableA where x = '';
> > >
> > > The field x is defined as char 40 .It looks like the field contains 40
> > > blanks. The SQL statement does NOT return these rows as expected. We have
> > > found that the syntax ' where trim(x) is null' works. But this is not
> > > acceptable for us, since we need to support several database systems.
> >
> > Er.. what is the exact problem definition?
> >
> > Does x contain spaces?
> > Does x contain no spaces?
> > Is x a null?
> > Is x a leak in the left plasma duct for the secondary warp core injector?
> >
> > > Now the question: Can we force oracle to accept the normal sql statement
> > > as shown above for our application ? Maybe a environment variable or
> > > similar ?
> >
> > Normal SQL? You call that normal SQL? Well.. some people also think that
> > StarTrek is real.
> >
> > The correct SQL looks something like:
> > SELECT
> > bluh
> > FROM foo
> > WHERE x IS NULL
> >
> > NULL is not a value. So don't treat it like one. Especially not when trying
> > to align the warp field while running at warp 9 through some weird and
> > funky spatial anomoly in a nebula containing pulsars.
> >
> > --
> > Billy
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
-- =================================================================== Brian Peasland oracle_dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Wed Jun 11 2003 - 14:19:30 CDT