[ORACLE] SQL -- if문 예시

declare
emp_record2 employees%rowtype;
begin
    SELECT * 
    into emp_record2
    FROM employees
    where employee_id = 101;
    
    if(emp_record2.commission_pct is null) then
         dbms_output.put_line('null이다 '||emp_record2.salary*12);
    else
        dbms_output.put_line('null이 아니다 '||emp_record2.salary*12+emp_record2.salary*emp_record2.commission_pct);
    end if;
    
    
    dbms_output.put_line(emp_record2.employee_id);
    dbms_output.put_line(emp_record2.last_name); 
    dbms_output.put_line(emp_record2.email);
    dbms_output.put_line(emp_record2.salary);
 
end;
/