可以在表中加入sysdate 记录时间 --建表语句 create table already_analyze_indexes as select t.owner as index_owner, t.index_name, t.table_owner, t.table_name from dba_indexes t where 1=2 --循环脚本 declare v_owner varchar2(200) :=' ...
#! /usr/bin/python for i in range(1, 10) : for x in range(1,i+1) : print i,'*',x, '=', i*x,'\t', print '\n' 这里和PL/SQL 不同的是范围末端不会出现在变量中,于是九九乘法表出现了10。 很诡异的 ...
select * from v$reserved_words order by keyword 关键字 A ALL, ALTER, AND, ANY, AS, ASC, AT B BEGIN, BETWEEN, BY C CASE, CHECK, CLUSTERS, CLUSTER, COLAUTH, COLUMNS, COMPRESS, CONNECT, CRASH, CREATE, CURSOR D DECLARE, DEFAULT, DESC, DISTINCT, DROP E ELSE, END, EXCEPTION, EXCLUSIVE F FETCH, FO ...