Oracle query on String [duplicate]

Question

I want to perform my query on a string in this format, xxxx/xxxx

where x is a number. when I perform it using the Oracle interface or my C# application I get this error:

ORA-00904: "xxxx/xxxx": invalid identifier

I performed this query:

SELECT * FROM "My Table" WHERE Field="xxxx/xxxx"

Frank · Accepted Answer · 2010-07-02 21:30:45Z

1

You should use single quotes aroung SQL character literals like xxxx/xxxx:

SELECT * FROM "My Table" WHERE Field='xxxx/xxxx'

answered Jul 2, 2010 at 21:30

Frank

2,64816 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1