How To Handle Table Column Named With Reserved Sql Keyword?

oracle, sql

Solution

Oracle uses double quotes `"` to escape reserved words.

insert into mytbl ("RANK")
select "RANK" 
from other_table

One other note, Oracle requires correct case as well.

Problem

I have a table that has a column named `RANK` which is a keyword in Oracle. Now I need to insert data in this table : ``` insert into mytbl (RANK) select RANK from other_table ``` when executing this query I got the following error : ORA-00907: missing right parenthesis How does one escape a keyword?

Original source