Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- IF THEN with logical operators
- SET SERVEROUTPUT ON;
- DECLARE
- v_num NUMBER := 9;
- v_num1 NUMBER := 1;
- v_text VARCHAR2(30) := 'TEXT CAN BE USED ALSO';
- BEGIN
- IF v_num < 10 AND v_text = 'TEXT CAN BE USED ALSO' THEN
- DBMS_OUTPUT.PUT_LINE('Inside the IF, if true');
- END IF;
- DBMS_OUTPUT.PUT_LINE('Outside of IF');
- END;
Advertisement