ITPub博客

http://www.hellodba.com/

drop TABLE MYTAB;drop TABLE MYTAB2;drop PROCEDURE MYPROC;drop PROCEDURE MYPROC2;CREATE TABLE MYTAB (I INTEGER PRIMARY KEY);CREATE TABLE MYTAB2 (I INTEGER, log varchar(100));CREATE PROCEDURE MYPROC ASBEGIN   DECLARE EXIT HANDLER FOR sql_error_code 301  select 201 a, '唯一...

http://www.askmaclean.com/archives/category/oracle/sql-tuning-oracle/page/2

http://blog.itpub.net/35489/

http://www.liualex.com/archives/2462

--DeadLock  死锁--Pre Step 先建好一个含唯一索引的Table， 初始化两条数据CREATE TABLE AAA ASSELECT 1 A, 1 B FROM DUAL UNION ALLSELECT 2 A, 2 B FROM DUAL;--Session 1UPDATE aaa SET a=11 WHERE b=1;U...

含LONG类型字段的表无法MOVE含LONG RAW类型字段的表无法MOVE

--多级嵌套表类型   CREATE OR REPLACE TYPE TAB_TYPE IS table OF varchar(100);CREATE OR REPLACE TYPE TAB_TYPE_V IS table OF TAB_TYPE;create or replace procedure Get_Data(P_Data in out TAB_TYP...

--游标类型传入参数  DECLARE    /*CURSOR cur_ttt IS  SELECT 1 a FROM dual;*/    TYPE typ_cur IS REF CURSOR;    val_cur typ_cur;    PROCEDURE temp_sp1(x...