Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to_number conversion

Lucy DiscoverDec 22 2010 — edited Dec 22 2010
The question is too simple.

I have a column which is declared as Varchar and has numbers in it. I need to select that column to find the data that ranges between 3000 to 4000.
Desc m.tablename
  CLASS_ID VARCHAR2 21
where I have class id stored in numbers from 0000 to 9999

I have to select class_id from m.tablename where class_id between 3000 and 4000
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2011
Added on Dec 22 2010
4 comments
128 views