ORACLE SQL

[ORACLE] SQL -- if문 예시

그릿GRIT 2021. 3. 21. 00:39
728x90
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
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;
/
cs