Begin
Select emp_age from t_employee where emp_code=121;
End;
The Select query has been written without the into clause, which is mandatory for a Select statement in a PL/SQL block.
As a result, the Select query cannot be displayed without assigning it to a variable.
Select emp_age from t_employee where emp_code=121;
End;
The Select query has been written without the into clause, which is mandatory for a Select statement in a PL/SQL block.
As a result, the Select query cannot be displayed without assigning it to a variable.