![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
_空指针_
快乐工作快乐玩
展开
-
DB2 存储过程,触发器,函数
SP:[code="sql"]CREATE PROCEDURE PROCESS_ADDNOTICE(IN RECORDOID BIGINT, IN STARTERID BIGINT, OUT RESULTSTATUS I...2010-04-29 11:17:41 · 292 阅读 · 0 评论 -
Oracle 内连接外连接
1. 内连接很简单select A.*, B.* from A,B where A.id = B.idselect A.*, B.* from A inner join B on A.id = B.id以上两句是完全等价的2. 左外连接select * from A a left join B b on a.id=b.idselect * from A a,B b wh...原创 2010-05-21 14:52:30 · 85 阅读 · 0 评论