-
编辑 删除
non
select (select l.ORACLE_USERNAME from v$session_wait sw, ...
-
编辑 删除
Locktree
E:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utllockt.sqlrem rem $Header: utllockt.sql 21-jan-2003.16:21:56 bnnguyen Exp $ locktree.sql rem Rem Copyright (c) 1989, 2003, Oracle Corporation. Al...
-
编辑 删除
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...
