- 博客(19)
- 收藏
- 关注
转载 SG_007_CHAPTER 10
User Access and Security对象权限,系统权限,角色权限。Creating and Modifying User Accounts:Configuring Account Authentication:用户连...
2009-11-03 14:16:06
78
转载 SG_007_CHAPTER 9
Other Database ObjectsCreating and Managing Sequences:序列值存在于数据字典中。Creating and Dropping Sequences:Create sequence...
2009-10-26 14:02:12
90
转载 SG_007_CHAPTER 8
Managing Views:Creating and Modifying Views:Create view view_name ASSelect column1,column2From tableWhere conditio...
2009-10-23 14:09:14
83
转载 SG_007_CHAPTER 7
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-si...
2009-10-21 19:28:36
74
转载 SG_007_CHAPTER 6
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-si...
2009-10-18 14:41:54
91
转载 SG_007_CHAPTER 5
Simple Joins: 使用符号‘=’相连2个表。属于内连接(inner join),因为只返回满足连接条件的数据。Complex Joins:除了在where中使用join 条件,还可以在where中添加限制条件。注意:当...
2009-10-15 13:40:31
107
转载 SG_007_CHAPTER 3(2)
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband...
2009-10-12 18:22:50
75
转载 SG_007_CHAPTER 3(1)
st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {...
2009-10-11 22:40:19
78
转载 SG_007_CHAPTER ONE
st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-sty...
2009-09-22 15:07:26
78
转载 Deferring Constraint Checks
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband...
2009-09-16 14:15:33
100
转载 Date and Time
Single-Row Functions: /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格;...
2009-09-06 15:20:00
95
转载 transaction-level or statement-level consistency; check constraints
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;(事务级的)返回的数据总是最新的SET TRANSACTION ISOLATION LEVEL READ COMMITTED;(语句级的)...
2009-09-03 10:13:23
71
转载 关联子查询 Correlated Subqueries
相关子查询 1.执行步骤: (1)外部查询得到一条记录并将其传入到内部查询。 (2)内部查询基于传入的值执行。 (3)内部查询从其结果中把值传回到外部查询,外部查询使用这些值来完成其处理。 例如: ...
2009-09-02 15:13:07
84
转载 SG_007_CHAPTER 4 (汇聚函数)
AVG([{DISTINCT | ALL}] ) 默认是allCORR( , )返回一对表达式的相关系数运算为:COVAR_POP(y,x) / (STDDEV_POP(y) * STDDEV_POP(x)).CO...
2009-09-02 15:12:18
121
转载 热备份
1、为什么要将表空间置于热备状态?这是因为OS在Copy Block时的无序性,也就是说在Copy数据文件的时候并不能保证最先Copy 出来的Block是Datafile header Block(因为Datafile head...
2009-09-02 15:07:28
160
转载 rollup cube 超汇聚函数
rollup,和 cube 的作用就是在汇聚函数的基础上进行超汇聚。 select ***from ***where ***group by A,rollup ( B );------在A被汇聚的基础上,在A...
2009-09-02 15:06:33
67
转载 cume_dist 函数
SQL> select * from wltest;A B C---------- ---------- --------------------1 10 jiejie2 30 gege3 25 mama4 50 baba...
2009-09-02 15:02:07
530
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人