sasfvs

Untitled

Jul 5th, 2017
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.33 KB | None | 0 0
  1. -- IF THEN with logical operators
  2. SET SERVEROUTPUT ON;
  3. DECLARE
  4.     v_num NUMBER := 9;
  5.     v_num1 NUMBER := 1;
  6.     v_text VARCHAR2(30) := 'TEXT CAN BE USED ALSO';
  7. BEGIN
  8.     IF v_num < 10 AND v_text = 'TEXT CAN BE USED ALSO' THEN
  9.         DBMS_OUTPUT.PUT_LINE('Inside the IF, if true');
  10.     END IF;
  11.         DBMS_OUTPUT.PUT_LINE('Outside of IF'); 
  12. END;
Advertisement