About this document

PL/SQL Block to Display EMP Name by Anonymous POS4z6aPv is a document available to read on EtoBox.

This PL/SQL block selects the employee name from the EMP table where the employee number is 101. It declares a variable to store the name, runs the select statement to retrieve the name and store it in the variable, then uses DBMS_OUTPUT to display a message stating the employee name is concatenated with the variable containing the name. The output shows the employee name is S Narasimha Rao.

Author

Anonymous POS4z6aPv

Language

EN