PL SQL Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. PL SQL
  4. 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>