小乙先生的博客

//下面是按照都好拆分，然后统计个数SELECT COUNT (*)FROM ( SELECT DISTINCT REGEXP_SUBSTR ( T .id, '[^,]+', 1, LEVEL ) id FROM ( SELECT id FROM XIAOYITEST WHERE ...

//分组取最新一条数据selecta.id,a.name,a.gradefrom(selectid,name,grade,row_number()over(partitionbynameorderbyid)rnfromt)awherea.rn<=1按照时间排序select t.* ...

CREATE TABLE XIAOYITEST ("ID" VARCHAR2(40 BYTE) NOT NULL ,"WD" VARCHAR2(60 BYTE) NULL ,"JD" VARCHAR2(60 BYTE) NULL ,"LRSJ" DATE NULL ) PARTITION BY RANGE (LRSJ) interval (numtoyMinterval(1,'...

TOP首先查看系统资源占用信息，TOP看一下ps -mp 4318 -o THREAD,tid,time再通过ps命令查看这个程序的线程信息,tid代码线程ID，time代表这个线程的已运行时间由上面TOP可知进程ID为15669printf “%x\n” 432910e9n有了线程ID的16进制后，再在jstack中查看进程堆栈信息(之所有拿到TID信息，主要是为了查找方...

declare num number := 1; sql_tem Varchar2(100);begin while num <= 10 loop for v_rlt in ( SELECT b. SID, b.serial# FROM v$process A, v$session b, v$sqlarea c WHERE A .addr = b.paddr A...

DECLARE xiaoyi VARCHAR2 (50) ;BEGIN xiaoyi := 'xiaoyiid' ; FOR item IN ( SELECT * FROM USER u WHERE u.id = xiaoyi ) LOOP dbms_output.put_line (u.id) ; END LOOP ;END ;...

--这里演示的是杀掉正在执行的指定sqldeclare num number := 1;sql_tem Varchar2(100);begin while num <= 5 loop for v_rlt in ( SELECT b. SID, b.serial# FROM v$process A, v$session b, v$sqlarea c WHERE ...

--这里演示的是备份表 可以多个表，如果需要请留言DECLARE sql_tem VARCHAR2(110); tableName VARCHAR2(110);BEGIN SELECT 'APP_TABLE_'||TO_CHAR(SYSDATE,'yyyymmddhh24miss') into tableName FROM dual; sql_tem := 'create t...