Blog: Oracle

We use between clause in a SQL statement to see if a value falls within a range. This works fine for numbers, and characters. But, if you have both numbers, and characters in a string then you will see unexpected results. Let us say we have a table with ranges. A1 to A99 is range1. A100 to A199 is range 2, and A200 to A299 is range 3. CREATE TABLE RANGES (FROM_VALUE VARCHAR2(10), TO_VALUE VARCHAR2(10), RANGE NUMBER(1)); INSERT INTO RANGES VALUES ('A1', 'A99', 1); INSERT INTO RANGES VALUES ('A100', 'A199', 2); INSERT INTO RANGES VALUES ('A200', 'A299', 3); Now, when we run the below SQL SELECT...

Read More