- 博客(9)
- 问答 (1)
- 收藏
- 关注
原创 Oracle 存储过程与函数
[code="sql"]CREATE OR REPLACE PROCEDURE pro_scmcbs_i6bill_filldata(group_code org_group.code%type, stockorg_code org_stockorg.code%type) AS ...
2013-03-05 11:06:47 94
原创 Oracle 游标
[img]http://dl.iteye.com/upload/picture/pic/123823/a31e0c58-0109-3356-b746-777a56be7abb.jpg[/img] [img]http://dl.iteye.com/upload/picture/pic/123825/187e94b2-d351-326b-9f46-2fae1071f27c.jpg[/img] ...
2013-03-03 19:57:11 109
原创 PL/SQL语句
[img]http://dl.iteye.com/upload/picture/pic/123777/03f585ec-53fe-3d2c-9513-933ab5b4d0cf.jpg[/img] [img]http://dl.iteye.com/upload/picture/pic/123779/48e5c341-b42f-3705-abbf-cf4f74926113.jpg[/img] ...
2013-03-02 18:08:18 107
原创 Oracle 视图
[img]http://dl.iteye.com/upload/picture/pic/123765/bccfa25c-d667-3d1f-a2e3-d170579fb731.jpg[/img] 如果视图失效 使用以下命令 [img]http://dl.iteye.com/upload/picture/pic/123767/83076fc9-7682-3f69-a9db-b4462df...
2013-03-02 10:28:15 57
原创 Oracle 序列
[img]http://dl.iteye.com/upload/picture/pic/123757/1621e448-bb84-3ca0-a9db-dc48d12c8bbd.jpg[/img] [img]http://dl.iteye.com/upload/picture/pic/123759/0edd56c7-35c8-322d-86b5-44a8cedd229d.jpg[/img] ...
2013-03-01 15:54:28 86
原创 Oracle 同义词
[img]http://dl.iteye.com/upload/picture/pic/123745/fb5fcc19-f576-3eb6-ba6e-6571f6e81d6f.jpg[/img] [img]http://dl.iteye.com/upload/picture/pic/123747/7b1e029b-264f-3233-8d65-e1fd6f829ee5.jpg[/img] ...
2013-03-01 15:23:29 71
原创 Oracle 权限
GRANT SELECT ON A.table TO B; GRANT INSERT ON A.table TO B; GRANT UPDATE ON A.table TO B; GRANT DELETE ON A.table TO B;
2013-03-01 14:40:44 90
原创 Oracle 分析函数
[img]http://dl.iteye.com/upload/picture/pic/123733/94f195f5-dffc-367c-93cf-0716fbab850c.jpg[/img] [img]http://dl.iteye.com/upload/picture/pic/123735/80f4e73b-de7f-31a9-bdaf-8775e49bb0ee.jpg[/img] ...
2013-03-01 13:32:13 74
原创 Oracle 集合运算
[img]http://dl.iteye.com/upload/picture/pic/123721/9b4617c0-6a8b-344e-9fae-503c7c0609ab.jpg[/img] [img]http://dl.iteye.com/upload/picture/pic/123723/d9b8a393-975b-3da4-88d8-7810101c53cb.jpg[/img] ...
2013-03-01 13:27:55 78
空空如也
密室之失踪人口:Oracle查询中十分诡异的现象
2011-11-30
TA创建的收藏夹 TA关注的收藏夹
TA关注的人