oracle插入sql
来源:互联网 发布:电脑桌面有什么软件 编辑:程序博客网 时间:2024/06/05 21:12
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 "
0 0
- SQL:oracle 插入时间
- oracle插入sql
- Oracle SQL 插入特殊字符
- sql oracle循环插入数据
- 数据库插入触发器 sql->oracle
- Oracle数据库sql插入随机数
- oracle插入时间sql语句
- Oracle:插入模板查询SQL语句
- Oracle 插入多条记录的sql
- Oracle中sql语句循环插入
- ORACLE SQL一条语句同时插入多个表
- Oracle存在修改,不存在插入记录 SQL
- Oracle Sql插入数据中特殊字符的处理
- 转-oracle pl/sql的批绑定和批量插入
- SQL语句往Oracle数据库中插入日期型数据
- SQL语句oracle中如何插入Date类型的数据
- 在SQL Server中连接Oracle,完成查询、插入操作
- oracle CLOB类型超过4000个字段sql插入方法
- 《PHP基础知识总结》PHP检查库或函数是否可用的方法
- Codeforces Round #301 (Div. 2)
- Linux中的特殊权限位
- 设计模式(行为型)之迭代器模式(Iterator Pattern)
- Dialogue System for Unity文档中英对照版(简雨原创翻译)完结篇(内置脚本使用,脚本API)
- oracle插入sql
- MAC打开EXE文件的三大方法
- css定位问题
- 数据结构—单链表的排序以及逆置
- BZOJ3884【数论】
- Spring学习笔记(14)-----------aop学习转折点(1)
- 我的 ”三个一切“
- C# 并行编程 之 并发集合 (.Net Framework 4.0)
- C C语言概述