Constraint

[Rashad1974]

I am getting this error mesage while verfying this constraint
ERROR ORA-00911 INVALIDE CARACTERE
ANY HELP WILL APPRECIATED TKS.

SELECT table_name
FROM user_tables
WHERE table_name IN (’MEMBER’, ’TITLE’, ’TITLE_COPY’, ’RENTAL’, ’RESERVATION’);

[mivey4]

I am getting this error mesage while verfying this constraint
ERROR ORA-00911 INVALIDE CARACTERE
ANY HELP WILL APPRECIATED TKS.

SELECT table_name
FROM user_tables
WHERE table_name IN (’MEMBER’, ’TITLE’, ’TITLE_COPY’, ’RENTAL’, ’RESERVATION’);

Out of curiosity......

What happens if you copy the statement from your post and paste it as a query instead of typing it? Do you recieve the same error?

mivey4

[vijaydiwakar]

I am getting this error mesage while verfying this constraint
ERROR ORA-00911 INVALIDE CARACTERE
ANY HELP WILL APPRECIATED TKS.

SELECT table_name
FROM user_tables
WHERE table_name IN (’MEMBER’, ’TITLE’, ’TITLE_COPY’, ’RENTAL’, ’RESERVATION’);

there is no problem at all inthis qry just copy it properly
and paste it

[Rashad1974]

even if I copy and paste I still have the same error message.
INVALIDE CARACTERE. ORA-00911

[mivey4]

even if I copy and paste I still have the same error message.
INVALIDE CARACTERE. ORA-00911

Hi Rashad1974,

Try running the following query and tell me if it results with the same error:

SELECT USERNAME FROM ALL_USERS
WHERE USERNAME LIKE 'A%';

Also, determine what character set you are running on the system if possible
by running:

SELECT * FROM SYS.PROPS$
WHERE NAME LIKE 'NLS%';

Then post the NLS_LANGUAGE, NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET VALUES here.

My suspicion is that either you're having some internal issues with your system
or there may be a problem with your installed characterset prohibiting you from executing your query.

Thanks.

[Rashad1974]

Hi Dear

This is what I get with fisrt select Statement
USERNAME
------------------------------
ANONYMOUS


I think I am using wrong character

[Rashad1974]

I got it right
the problem was that I was using wrong character


tk u very much.

[mivey4]

I got it right
the problem was that I was using wrong character


tk u very much.

Great!! I am happy you have a resolution.
Have a good one.

[Killer42]

...the problem was that I was using wrong character

Wrong quote character? It looked like it, when I pasted your query into Notepad. With all the different fonts around, you have to watch that.