Re: Oracle SQL bug in 220.127.116.11
Date: Thu, 10 Feb 2011 06:30:08 +0100
"DG problem" <skatefree_at_gmail.com> a écrit dans le message de news:
| 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 '
| '<'||Y||'>', Y
| ( select 'WHY ' Y from dual) x
| Y = 'WHY'
| P.S. Yes I know that 9i is well and truly obsolete :)
Read the following thread in AskTom:
Michel Received on Wed Feb 09 2011 - 23:30:08 CST