Unique ID issue in Oracle 10g

Databases
1

Hello, everyone,

I have an Oracle 10g database, and in it is a table where the first column is a VARCHAR 36 and contains Oracle generated UIDs.

I am trying to run a SELECT query that gets a corresponding date 19 where the UID = ‘{ a 36 character long UID}’. I am getting the ORA-01722 invalid number error message.


SELECT SUBMIT_DATE

FROM schema.tableA

WHERE UID = '2c90c23129f120250129f18eb7740006'

I’ve tried using TO_CHAR() and CAST() to no avail. What am I missing?

V/r,

:slight_smile:

2

UID is a reserved keyword in Oracle. If I put the column name in double-quotes, the query will run with no issues.


SELECT SUBMIT_DATE

FROM schema.tableA

WHERE "UID" = '2c90c23129f120250129f18eb7740006'

(Is there a way to mark this as resolved??)

V/r,

:slight_smile: