Friday, 25 May 2012

What is the error in the following code(Given)? PL SQL

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.