Database Administration (MOSC)

MOSC Banner

Querying value with Question mark ?

edited Feb 14, 2010 6:20PM in Database Administration (MOSC) 23 commentsAnswered
Hi

I have a table with a column called POLISVNO where all the POLISVNO start with a question mark (?).

eg.

?412446355 1

?412709225 2

when I run the following query

select POLISVNO from AWD_ABC380 where POLISVNO like '?412%';

it returns zero rows.

also when I run select POLISVNO from AWD_ABC380 where POLISVNO like '%?%';

it returns no rows back.

I have created a test table in another database and inserted values these values in there and when I run the queries it actually returns the values.

The only thing I can think of is my NLS_CHARACTERSET???

The thing is, it worked in the past and now all of a sudden it doesn't work. No database changes like parameters have been made on this database?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center