In TSQL I could use something like Select [table] from tablename to select a column named "table".
How do I do this for reserved words in oracle?
Edit: I've tried square braces, double quotes, single quotes, and backquotes, they don't work...
As a further clarification, I have a column which someone named comment. As this is a reserved word oracle is chucking a wobbly trying to select with it, its failing when parsing the query. I've tried Select "comment" from tablename but it didn't work. I'll check case and come back.
Question&Answers:
os 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
