-
编辑 删除
Activity Transaction
SQL> create table a (b number, c varchar2(30));表已创建。SQL> insert into a values (2,'allo');已创建 1 行。SQL> select * from v$rollname; USN NAME-------...
-
编辑 删除
Undo-Monitor
1 why undo？ What made the undo do that? What need? Undo (Rollback) serves two purposes. It is the fundamental mechanism that allows the Reader...
-
编辑 删除
春风沉醉的晚上
鳞鳞月波如秋霜 晚风清扬相思荒 单影拽身问何宿 酒植愁肠卧长廊
-
编辑 删除
MTTR And Self-tuning CheckPoints
With Oracle Database 10g, the database can self-tune checkpoints activity to achieve good recovery times with low impact on normal throughput. With automatic checkpoint ...
-
编辑 删除
Private Redo Strands&IMUlatch
1 log file switch (private strand flush incomplete) User sessions trying to generate redo, wait on this event when LGWR waits for DBWR to complete flushing redo fr...
-
编辑 删除
青年**
七尺长衫出湘江 激扬文字斗狐狼 工农运动酬壮志 井冈朱毛着红装
-
编辑 删除
立桥沽高
瞩立钱塘桥 微月不见羞 桥势如贯虹 觉道资无休 春风从西来 百禄遍神州 奔走似朝东 峥嵘岁月愁 势将跨寰宇 两向各奔走 ...
-
编辑 删除
Unused&Constraint
1 constraints defined on the column would be removed by the UNUSED command：SQL> desc LOCATIONS; 名称 &nb...
-
编辑 删除
DML Views
1 view of insertable,updable,deletableSQL> CREATE VIEW V4(or_no, or_date, cust_id) 2 AS SELECT order_id, order_date, customer_id 3 FROM orders 4 WHERE order_...
-
编辑 删除
Time_zone
1. How to check time zone ?a db:SQL> select dbtimezone from dual;DBTIME------+00:00@ Note that the database timezone is also included in both database_properties and props$ views:@ SQL> SELEC...
-
编辑 删除
PAD
I made my speech longer by padding it with a few jokes;Ipad2,Ipad3 and so on.Now Let's get to the pad of the Oracle® Database SQL Reference:1 left Pad：SQL> select lpad('...
-
编辑 删除
Only select on External Tables
QUESTION EMPDET is an external table containing the columns EMPNO and ENAME. Which commandwould work in relation to the EMPDET table?A. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234;B. DELETE FRO...
-
编辑 删除
Correlated Subqueries
correlated subquery is a subquery (a query nested inside another query) that uses values from the outer query in its WHERE clause. The sub-query is evaluated once for each row processed by the outer q...
-
编辑 删除
Multitable Insert
First of all,In a multitable insert, you insert computed rows derived from the rows returned from the evaluation of a subquery into one or more tables.classified index as follows:1 unconditional mult...
-
编辑 删除
原创书写开篇sqltuning
http://www.itpub.net/thread-1506894-1-1.html
-
编辑 删除
version_count
www.google.com+metalink.oracle.com+oracle+yourselft=渔 version_count原意这么说的：Number of child cursors that are present in the cache under this parent
-
编辑 删除
OFFLINE DROP
文档：1 OFFLINE Specify OFFLINE to take the datafile offline. If the database is open, you must perform. media recovery on the datafile before bringing it back online, because a che...
-
编辑 删除
脚本综合
脚本综合
-
编辑 删除
delete
http://www.itpub.net/viewthread.php?tid=578721&extra=&highlight=delete&page=2 http://www.itpub.net/viewthread.php?tid=578721&extra=&highlight=delete&page=2
-
编辑 删除
一番千秋篇
惑天欲何为？经夏春秋冬，或是舞夜雪，却也雨打夜，亦可肃秋风生机春含蓄，惑人欲何求？汲汲碌功利。天道可沧桑有情亦可老纵是百年身驹隙窥千秋功否？利否躬身影蹒跚趋之委求懒唯醉可畅还遥想瞩北国...
