PL/SQL Select Into
Oracle PL/SQL Select Into Example
DECLARE v_user varchar2(80); BEGIN Select u.name Into v_user From users u, customers c Where c.user_id = u.user_code And c.customer_id = 1 ; dbms_output.put_line(v_user); END;
DECLARE v_user varchar2(80); BEGIN Select u.name Into v_user From users u, customers c Where c.user_id = u.user_code And c.customer_id = 1 ; dbms_output.put_line(v_user); END;