Re: Oracle SQL bug in 9.2.0.8

"DG problem" <skatefree_at_gmail.com> a écrit dans le message de news: 2cd5fcc9-694f-4a81-bbc4-29eaf9eaf9d5_at_m27g2000prj.googlegroups.com...
| I've only just come across this possible SQL bug and was wondering why
| this SQL returns a result? I got it through an email and had to change
| it to Oracle's syntax as the original used the concat operator of +
| and it didn't use DUAL.
|
| -- Note the spaces after 'WHY '
| select
| '<'||Y||'>', Y
| from
| ( select 'WHY ' Y from dual) x
| where
| Y = 'WHY'
| ;
|
| P.S. Yes I know that 9i is well and truly obsolete :)

Read the following thread in AskTom:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2668391900346844476

Regards
Michel Received on Wed Feb 09 2011 - 23:30:08 CST