Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Between and operator for text value

SQL> SQL> SQL> BEGIN   2    IF 'C' BETWEEN 'A' AND 'D' THEN   3        DBMS_OUTPUT.PUT_LINE('TRUE');   4      ELSE   5         DBMS_OUTPUT.PUT_LINE('FALSE');   6      END IF;   7  END;   8  / TRUE PL/SQL procedure successfully completed. SQL>