End of query request - what is wrong

jgRugby_123098 · 2023-09-25T14:05:19+00:00

There was an error rendering this rich post.

I continue to get an end of query request and not sure what I'm doing wrong. Please help me understand what I'm missing. I have tried adding and adjusting - just not working. Below is the query.

SELECT *
FROM CHARGE_DETAIL
WHERE INVOICE_NUMBER =
217653436,
217668183,
819802440,
820092602,
END

Find more posts tagged with

Accepted answers

marcel_luthi

Where is this query being used? In general the syntax looks odd, if you care about the specific invoice numbers the general MySQL query would be:

SELECT *

FROM CHARGE_DETAIL

WHERE INVOICE_NUMBER IN (217653436,

217668183,

819802440,

820092602)

Does this helps?

GrantSmith

@jgRugby_123098

Since your invoice number field is a string you need to use strings in your IN clause. You can do this by putting them in single quotes

SELECT *
FROM CHARGE_DETAIL
WHERE INVOICE_NUMBER IN ('217653436',
'217668183',
'819802440',
'820092602')

All comments

marcel_luthi

Where is this query being used? In general the syntax looks odd, if you care about the specific invoice numbers the general MySQL query would be:

SELECT *

FROM CHARGE_DETAIL

WHERE INVOICE_NUMBER IN (217653436,

217668183,

819802440,

820092602)

Does this helps?

jgRugby_123098

Marcel -

What you provided seems to get me off that trap. Now, I'm running into the error of :

ORA-0122:invalid nubmer

I will do some research on this. Do you happen to know what this means?

Thank you,

jgRugby_123098

I looks like I now need to change the database field from a string to a number.

GrantSmith

@jgRugby_123098

Since your invoice number field is a string you need to use strings in your IN clause. You can do this by putting them in single quotes

SELECT *
FROM CHARGE_DETAIL
WHERE INVOICE_NUMBER IN ('217653436',
'217668183',
'819802440',
'820092602')