All SELECT statements in PL-SQL must have an INTO clause; therefore another
method is needed to display output to the console.
DBMS_OUTPUT.PUT_LINE('TEST OUTPUT');
salary := 24000;
dbms_output.put_line(salary);
-- Display Output, need to execute set command, within SQL-Plus session
set serveroutput on size 9999
dbms_output.put_line('Account Restricted process: ' || total);
|
|
