摘要:
create table t1 (id char(10) primary key,a1 char(10),a2 char(10)); begin for i in 1 .. 1000loop insert into t1 values(i,i,'a'||i); end loop ; com... 阅读全文
摘要:
create table t1 (id char(10) primary key,a1 char(10),a2 char(10)); begin for i in 1 .. 1000loop insert into t1 values(i,i,'a'||i); end loop ; com... 阅读全文
摘要:
iot表测试: 在create table语句后面使用organization index,就指定数据表创建结构是IOT。但是在不指定主键Primary Key的情况下,是不允许建表的。 create table t2 (id int primary key,a1 char(10),a2 cha... 阅读全文
摘要:
iot表测试: 在create table语句后面使用organization index,就指定数据表创建结构是IOT。但是在不指定主键Primary Key的情况下,是不允许建表的。 create table t2 (id int primary key,a1 char(10),a2 cha... 阅读全文
摘要:
SQL> select * from (select * from t1 order by id ) where rownum select * from (select * from t2 order by id ) where rownum select dbms_metadata.get... 阅读全文
摘要:
SQL> select * from (select * from t1 order by id ) where rownum select * from (select * from t2 order by id ) where rownum select dbms_metadata.get... 阅读全文
摘要:
SQL> select * from t1 where id>=1 and id explain plan for select id from t1 where rownum select * from table(dbms_xplan.display());PLAN_TABLE_OUTPU... 阅读全文
摘要:
SQL> select * from t1 where id>=1 and id explain plan for select id from t1 where rownum select * from table(dbms_xplan.display());PLAN_TABLE_OUTPU... 阅读全文
摘要:
#!/usr/bin/perluse AnyEvent;use AnyEvent::HTTP;my $cv = AnyEvent->condvar;sub doit{ my $url = shift ; return if not defined $url; $cv->begi... 阅读全文
摘要:
#!/usr/bin/perluse AnyEvent;use AnyEvent::HTTP;my $cv = AnyEvent->condvar;sub doit{ my $url = shift ; return if not defined $url; $cv->begi... 阅读全文