ITPub博客

http://www.eygle.com/archives/2011/06/oracle_fileheader_scn.html

http://blog.csdn.net/wzy0623/article/details/3089712

---power第二个参数即多少次方 ----2的0次方,0可以写成00或者0,仅是表达方式不同,经果是一样的SQL> select power(2,00) from dual; POWER(2,00)-----------      &...

http://www.xifenfei.com/1092.html 小结:         1,10200事件使用             2,设置db_fi...

 http://hi.baidu.com/songyunkui/item/04aba589f7ffa705100ef3c1----分别创建两个源表和目标表SQL> set time on13:10:49 SQL> set timing on 13:11:13 SQL> create table t_source(a int,b int);...

SQL> desc t_sql;Name Type           Nullable Default Comments ---- -------------- -------- ------- -------- A    INTEGER &...

昨天，小拇指有些酸痛，因为Ctrl+C，Ctrl+V的操作频繁了些。今天用UltraEdit的正则表达式，减少了麻烦。    包含很多关键词的文本文档，每个关键词占一行。现在要查看这些词的百度搜索结果。...

附录:http://czmmiao.iteye.com/blog/1236562       --网上关于db link讲解----创建db link语法CREATE [ SHARED ] [ PUBLIC ] DATABASE LINK dblink  [ CONNECT TO&nbsp...

http://www.hellodba.com/reader.php?ID=76&lang=CN

http://www.hellodb.net/tag/%e5%ad%98%e5%82%a8

SQL> select cluster_name,tablespace_name from user_clusters;                      ...

本文测试cluster table     ---语法CLUSTER cluster (column [, column ]...) ---cluster子句语义CLUSTER Clause            ...

---如iot分区,overflow segment也基于主键进行对应分区                       &nb...

oracle iot索引组织表(一)                            ...

 SQL> select * from t_like; A--------------------------------------------------------------------------------山西省北京 北京   SQL> create or replace procedure pr...

http://docs.oracle.com/cd/E11882_01/server.112/e16638/instance_tune.htm#PFGRF94494

2月15日上班即初五

SQL> create table t_test(a int); Table created SQL> insert into t_test select 1 from dual connect by level<=9e5; 900000 rows inserted SQL> commit; Commit complete--查...

仅适用于系统表空间oracle@$ strings system01.dbf |grep "[0-9]\{1,2\}\.[0-9]\{1\}" | grep -i "catalog views"COracle Database Catalog Views Release11.2.0.3.0 - 64bit Production"DBMS_REGISTRY_SYS....

---语法{ COMPRESS [ BASIC            | FOR { OLTP               &nb...