Let’s take a look at PL/SQL Assignment Statements

Assignment Statements

• Assignment operator: : =

• Variable being assigned to a new value is on left side of assignment operator

• New value is on right side of operator
student_name : = ‘John Miller’;
student_name : = current_student;

Displaying PL/SQL Program
Output in SQL*Plus

• Command to output data from a PL/SQL program in SQL * Plus:
DBMS_OUTPUT.PUT_LINE ( ‘ output string ’ ) ;
DBMS_OUTPUT.PUT_LINE ( ‘ Current Output : ’ ) ;
Executing a PL/SQL Program
in SQL*Plus

• Copy program code from Notepad to SQL*Plus

• Type / to execute