- 博客(7)
- 收藏
- 关注
转载 oracle---synonym, sequence,view
introduce the synonym, sequence and view in oracle[@more@]同义词 synonym create synonym synonym for schema.object 隐...
2007-09-30 12:30:05
121
转载 Java基础之关键字
1, which of the following are keywords or reserved words in java? a) if b)then c)goto d)while e)case f)sizeof ...
2007-09-10 16:10:08
121
转载 oracle sql 语法之 over (partitioin by ...)
select * from test 数据: A B C 1 1 1 1 2 2 1 3 3 2 2 5 3 4 6 ---将B栏位值相同的对应的C 栏位值加总 select a,b,c...
2007-04-29 15:39:41
146
转载 选用 IN 还是 EXISTS,哪个性能更好
有时候会将一列和一系列值相比较。最简单的办法就是在where子句中使用子查询。在where子句中可以使用两种格式的子查询。第一种格式是使用IN操作符:... where column in(select * from ... w...
2007-04-28 15:48:57
256
转载 随机取表中数据
在pl/sql中有张1000条记录的表。如果想随机抽取其中50条记录该如何操作呢?[@more@]利用select *from (select *from t order by dbms_random.value) where ...
2007-04-02 17:12:19
90
转载 Oracle/PLSQL: Foreign key with cascade delete
Source:http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.phpWhat is a foreign key?A foreign key means...
2007-02-06 14:32:22
122
转载 Linux / Unix Command: bc
bc is an arbitrary precision calculator language.[@more@]If you need to deal with Big Numbers, the unix bc is the ...
2007-02-05 17:03:59
75
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人