Variable case resolution in PL/SQL

1. Scalar:

AG1:

Declare

V_ename emp.ename%type;--itself is called a univariate

Begin

Select Ename to V_ename from EMP where empno=&no;

Dbms_output.put_line (' Employee Name ' | | V_ename);

End

Ag2:

Declare

Type test1 is record (T1 emp.ename%type,t2 emp.sal%type);--Define record type variables

V_tt Test1;--v_tt is a compound variable test1

Begin

Select Ename,sal to V_tt from EMP where empno=&no;

Dbms_output.put_line (' Employee Name ' | | v_tt.t1| | ' Salary ' | | V_TT.T2);

End

AG3:

Declare

Type test2 is table of Emp.ename%type index by Binary_integer;--pl/sql table type

V_ename test2;

Begin

Select Ename to V_ename (0) from EMP where empno=7788;

Dbms_output.put_line (' Employee Name: ' | | V_ename (0));

End

Variable case resolution in PL/SQL