[antlr-interest] Integer literal ending problem

[Norman Dunbar]

On 14/12/11 08:36, Ivan Brezina wrote:

> Are you sure? For example in Oracle you can have statements like this:
>
> SELECT 1D FROM DUAL; -- "D" is an alias for column 1
> SELECT * FROM A WHERE A.C = :1AND A.D = :2; -- Note there is no gap
> between bindvar and "AND".

Oracle does a lot of weird stuff in syntax checks etc. For interest, see 
my own blogon the matter from this very moring (coincidences happen 
frequently!) 
http://qdosmsq.dunbar-it.co.uk/blog/2011/12/slightly-weird-oracle-stuff/


But for a better one, see Tanel Poder's blog at 
http://blog.tanelpoder.com/2011/01/10/is-this-valid-sql-syntax/.


Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767