insert all into Sta_ApplySmcAttach(ApplyId,UserId,UserName,CompanyId,CompanyName,Nominator,NominatorOfficePhone,NominatorMobile,NominatorEmail,NominatorFaxNumber,InterDocNo,InterDocExpiryDate,InterDocTypeCodes,InlandDocNo,InlandDocExpiryDate,InlandDocTypeCodes,Reason) values ( ?ApplyId , ?UserId , ?UserName ,CompanyId,CompanyName,Nominator,NominatorOfficePhone,NominatorMobile,NominatorEmail,NominatorFaxNumber,InterDocNo,InterDocExpiryDate,InterDocTypeCodes,InlandDocNo,InlandDocExpiryDate,InlandDocTypeCodes, ?Reason ) with a as (select companyid, companyname from bas_company), b as (select companyid,PersonnelName Nominator,OfficePhone NominatorOfficePhone,Moblie NominatorMobile,Email NominatorEmail ,FaxNumber NominatorFaxNumber from bas_compersonnel where typecode='03'), c as (select companyid, docno InterDocNo, expirydate InterDocExpiryDate,AuditShipTypeCodes InterDocTypeCodes from (select * from bas_interdoc order by issuedate desc ) ), d as (select companyid, docno InlandDocNo, expirydate InlandDocExpiryDate,AuditShipTypeCodes InlandDocTypeCodes from (select * from Bas_InlandDoc order by issuedate desc ) ) select a.companyid, companyname,Nominator,NominatorOfficePhone,NominatorMobile,NominatorEmail,NominatorFaxNumber,InterDocNo,InterDocExpiryDate,InterDocTypeCodes,InlandDocNo,InlandDocExpiryDate,InlandDocTypeCodes from a, b, c, d where a.companyid=b.companyid(+) and a.companyid=c.companyid(+) and a.companyid=d.companyid(+) and a.companyid= ?CompanyId and rownum=1 "
oracle sql插入,oracle插入sql
最新推荐文章于 2024-07-17 19:00:48 发布