PL/SQL (MOSC)

MOSC Banner

Oracle 11g - Data restriction from VARCHAR2 Column

edited Nov 11, 2013 4:15AM in PL/SQL (MOSC) 15 commentsAnswered
Dear All,

I am querying customer numbers (data type is Varchar2) from 41000 to 41299 in hz_cust_accounts table using below query

SELECT *
FROM hz_cust_accounts
WHERE account_number >= '41000'
AND account_number <= '41299'

But i am also getting 4140, 4150 customer data.

Please suggest me How to restrict the data between the range of customers from 41000 to 41299.

Regards,

Anjana J

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