Skip to Main Content

Oracle Database Discussions

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!

ORA-01747: Oracle Reserved Words

user3636719Oct 1 2012 — edited Oct 1 2012
Hello Gurus,

I am having issue with Oracle reserved words, one of the application is using table which has NUMBER as column. I am not able to query that table matching database with NUMBER column.

HERE
select a.*
from DOC a , FOLDER B
where a.NUMBER= B.INCIDENT_ID
and b.open = 'Closed';
I tried double quotes (“”) and sigle quotes too, none of them worked.

Any help greatly appreciated. Thanks.
This post has been answered by unknown-7404 on Oct 1 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2012
Added on Oct 1 2012
12 comments
2,398 views