Dealing with reserved words

From: <jgotthelf_at_my-deja.com>
Date: Sun, 10 Sep 2000 19:02:30 GMT
Message-ID: <8pglrt$1g2$1@nnrp1.deja.com>

Hi,

I am wondering if there is a way to deal with reserved words in Oracle SQL statements. For example, the following bizarre looking SQL is valid in SQL Server:

create table [table] ([order] char(10), [where] char(5))
insert into [table] ([order], [where]) values ("1", "room1")
insert into [table] ([order], [where]) values ("3", "room3")
insert into [table] ([order], [where]) values ("2", "room2")
insert into [table] ([order], [where]) values ("4", "room4")

select [order], [where] from [table] where [where] like "room%" order by [order]

Is there a similar way to get Oracle to accept field names, etc., that are reserved words?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 10 2000 - 14:02:30 CDT