Reserved words in Oracle query

[email protected] Mon, 24 Mar 2003 12:04:02
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-925180-2003.03.24-11.45.30--gcdod-oracle#[email protected]>
Hi

We have a web application that currently runs quite happily with SQL 
Server and Access databases. Some of the table column names are reserved 
words like "Unique" and "Ascending" for historical reasons. What we 
normally do is just put [] round the elements in the query to ensure that 
there is no confusion.

The programmer who is now responsible for the databases and in particular
Oracle does not want to do this but instead wants to rewrite the whole 
system to prefix all table and field names with "FF_" but is reluctant to 
explain his reasoning for this.

What are the implications with leaving [] around field names in Oracle? 
Is it supported?
Are there likely to be any other issues?

I'd appreciate any views as this just seems to me like it is going to add 
major delays and complications to this particular project.

Regards
Graham
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].