Oracle: sort by column with reserved name

Question

How can I sort by column name that is reserved word? For example:

select * from some_table t1 order by t1.mode;

mode is our reserved word. It cannot be changed, moreover I need select to be used with identifier t1. So far I've tried:

order by t1."mode", "t1.mode", t1.'mode', 't1.mode'

Without any luck

You pasted 10g reserved word list, I'm working with 11g :) docs.oracle.com/cd/E14072_01/server.112/e10592/ap_keywd.htm — kamil
– kamil, Commented Dec 13, 2012 at 15:05

Codo · Accepted Answer · 2012-12-13 15:07:36Z

3

The correct way is to use double quotes. But if you use double quotes, column names become case-sensitive. So it's probably

ORDER BY t1."MODE"

answered Dec 13, 2012 at 14:59

Codo

79.7k18 gold badges176 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Funny thing is that I didnt even think about it :) Thank you so much!