Oracle/PL/SQL
15일차 # 2-6: 변수 선언 및 사용
Bohemian life
2012. 4. 24. 21:00
set serveroutput on
declare
h_date date;
e_sal number(6) not null := 10000;
location varchar2(13) := 'Atlanta';
c_comm constant number := 1400;
BEGIN
h_date := sysdate();
dbms_output.put_line(
to_char(h_date, 'YYYY"년" MM"월" DD"일입니다"'));
e_sal := e_sal + c_comm + 10;
END;
/