[odb-users] ODB compiler for oracle, double qoutes SQL?statements

[Tony Rietwyk]

Hi Boris, 

> Sent: Wednesday, 21 November 2012 11:11 PM
> 
> If we only quote keywords, not only will we have to maintain a list of all
> known keywords for each database, but we will also have an inconsistency
of
> non-keywords being converted to upper case while quoted keywords
> keeping their original case. 

You are quite right.  I was only thinking of the 'spaces in names' case for
quoting.  

> Perhaps a better solution would be to provide an option which instructs
the
> ODB compiler to convert all the database identifiers to upper case. While
> ODB internally will still use quotes, one will be able to write custom SQL
> without quoting and rely on Oracle to implicitly uppercase the
identifiers.
> 
> What do you think?
> 
> Boris

That sounds a good idea.  

Tony