insert into employee
(e_no, e_name, e_gender, e_birth, e_hiredate, e_enddate, e_phone, e_email, E_ADDRESS
,e_status, e_rank, e_password, e_auth
,e_profile, dept_name, reg_date, mod_date, reg_id, mod_id
)
values (to_char(sysdate,'YYYYMM_')||lpad(SEQ_EMPLOYEE_NO.nextval,8,0)
,'박정원','남',to_char(sysdate, 'YYYY-MM-DD'), sysdate, sysdate, '010-0000-0000', '1234@asdf.com','서울시 어쩌구 저쩌구'
,'재직중', '시설장', '12341234', 'admin', 'image.jpg', (select cd_value from common_cd where cd ='dept0101')
, sysdate, sysdate, '16040100', '1604010');