sql

update m_mpm_erp_project p set p.department_id = (
       select d.dept_id from t_system_staff s ,t_system_dept d
              where s.staff_id = p.project_manager_id and s.dept_code = d.dept_code
)

alter   table m_bag_info_change  modify project_type varchar2(50)


<c:out value="${bagInfoList}" default="你妹啊"></c:out>

sp.buildDate >=
                  to_date('2004-1-1 00:00:00', 'yyyy-mm-dd hh24:mi:ss')