Declare
V_dept_id xxdtj_Employees.department_Id%Type:=10;
Begin
Update Xxdtj_Employees Set Salary=Salary + 1000
Where Department_Id=V_dept_id;
Dbms_Output.Put_Line(V_DEPT_ID);
End;
OUTPUT :
10
V_dept_id xxdtj_Employees.department_Id%Type:=10;
Begin
Update Xxdtj_Employees Set Salary=Salary + 1000
Where Department_Id=V_dept_id;
Dbms_Output.Put_Line(V_DEPT_ID);
End;
OUTPUT :
10
No comments:
Post a Comment