How can I use an oracle keyword as an alias?

Question

I would like use the following sql statement in my code:

SELECT ..., DATA.EXT_ID AS NUMBER, ... FROM DATA;

But I can't since "NUMBER" is a keyword. Is there any way around this? Thanks!

Where are the duplicates? I searched around but didn't find anything — anonymouse, Mar 02 '16 at 23:41

score 3 · Accepted Answer · answered Mar 02 '16 at 23:29

3

Use double quotes around the keyword:

SELECT DATA.EXT_ID AS "NUMBER" FROM DATA;

answered Mar 02 '16 at 23:29

MT0

1 Answers1