Variable Definition method

11) Variable Definition method//Define a V_name variable,//type size consistent with the EMP table ename field V_name Emp.ename%type;   Defines a v_emp variable, which is a record type//can store one row of record information v_emp Emp%rowtype;     Declare v_emp emp%rowtype;--record variable begin SELECT * into V_emp from EMP where empno=7900;     Dbms_output.put_line (V_emp.ename);  Dbms_output.put_line (v_emp.sal); End

Variable Definition method