![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
database
2的10次方
这个作者很懒,什么都没留下…
展开
-
ORACLE
ORACLE What is a DataBase Manage System?DMS = database + instance;What is a database? Thrice model 1.physically – All kinds of files database = data(*.dbf) + log(*.log) + control(*.ctl) + ...;The t原创 2015-06-29 23:33:10 · 241 阅读 · 0 评论 -
oracle 2
concurrency VS consistencyHow to solve this problem? –lock DML DDLtransaction isolation leveldirty read : data which is not commit unrepeatable read : data which is not the same at the second time原创 2015-06-30 21:36:19 · 217 阅读 · 0 评论 -
SQL SELECT
SELECT执行顺序对理解sql非常关键。因此按照语句执行顺序作了调整 FROM t t表或 t1 [join type] join t2 on , 根据on条件,生成虚表vt1 WHERE 筛选条件,过滤vt1,生成vt2 GROUP BY vt2按条件合并成组,生成vt3 SELECT vt3按列投影,生成vt4 ORDER BY 注意:排序不生成vt表,而是返回游标对象。 扩展:原创 2017-04-30 10:22:30 · 342 阅读 · 0 评论