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].