'Between...and' operator for text value : Between and « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Between and

'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>








Related examples in the same category

1.'Between...and' operator for number value
2.'Between...and' operator for Date type
3.'Between...and' operator converts text to date type