![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
玩火的小孩
这个作者很懒,什么都没留下…
展开
-
oracle 函数生成流水号
CREATE OR REPLACE FUNCTION create_code(p_code varchar2,p_length number) return VARCHAR2 as PRAGMA AUTONOMOUS_TRANSACTION; v_count number;v_code varchar2(40);v_lock code_base%rowtype;begin原创 2015-09-06 09:34:54 · 966 阅读 · 0 评论 -
oracle 行列转换
with t as (select '打包' t, to_char(q.provider_code || '共' || count(1) || '个包裹') n from rnrsbrand.query_auction q where q.status in (2, 3) group by q.provider_code union select '捆包'原创 2016-09-01 16:37:11 · 251 阅读 · 0 评论 -
查找oracle 需要优化的SQL (一) 之v$SQLarea
1、按物理读 读取磁盘次数 select s.SQL_FULLTEXT,s.DISK_READS/s.EXECUTIONS from v$sqlarea s where s.EXECUTIONS >0 and s.DISK_READS >1000 order by s.DISK_READS/s.EXECUTIONS desc 2.、按内存消耗 select s.SQL原创 2016-09-05 16:44:40 · 1112 阅读 · 0 评论 -
oracle 会话参数
1、 oracle sys_context()函数select sys_context('USERENV','AUTHENTICATION_TYPE') from dual;--用户的认证类型select sys_context('USERENV','BG_JOB_ID') from dual;--当前指定id的会话是否为oracle后台程序建立,不是则返回nullsele原创 2016-09-20 10:49:08 · 935 阅读 · 0 评论