Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Code - Calling a column that has a reserved keyword as its name

835670Jul 19 2013 — edited Jul 22 2013

Hello all,

As seen in the title, one of the database tables that I'm trying to extract information from has one of its columns as a reserved keyword.

I am trying to run some testing SQL code on Oracle SQL Developer.

The simple code I'm trying to run is:

select number

from specific_table

Result is:

ORA-01747: invalid user.table.column, table.column, or column specification

01747. 00000 -  "invalid user.table.column, table.column, or column specification"

Is there some sort of way of getting around this?
Any help would be greatly appreciated.

Thank you!
This post has been answered by Solomon Yakobson on Jul 19 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2013
Added on Jul 19 2013
4 comments
2,760 views