Shell Programming and Scripting

[define emp_no = &empno 
 
select * from emp where empno = &emp_no;
 
ACCEPT   i_sum    PROMPT 'Do you want the total sal  of all emp? (y;n): ';

 BEGIN
        IF UPPER('&i_sum') = 'Y' THEN
           select sum(sal) from emp ;
         END IF;
   END ;
]

set serveroutput on
set verify off;
define emp_no = &empno; 
select * from emp where empno = &emp_no;
ACCEPT i_sum PROMPT 'Do you want the total sal of all emp? (y;n): ';
declare
v_sal number;
BEGIN
IF (UPPER('&i_sum') = 'Y') THEN
select sum(sal) into v_sal from emp;
dbms_output.put_line('Total_sal ' || to_char(v_sal));
END IF;
END ;
/