摘要： SELECT fcr.outfile_name FROM fnd_concurrent_requests fcr WHERE fcr.request_id = 435492 阅读全文

摘要： select * from afa_ste_receipt_interface a where a.creation_date >= TO_DATE('20120325170000', 'yyyy/mm/dd hh24:mi:ss') 阅读全文

摘要： SELECT UPPER(F.TABLESPACE_NAME) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100, 2), '990.99') "使用比", F.TOTAL_BYTES "空闲空间(M)", F... 阅读全文

摘要： --测试自定义异常create or replace package body exception_test_pkg is exp_difin_error exception; g_msg_data varchar2(2000); procedure test(p1 in number, p2 in number) is begin if p1 > p2 then g_msg_data := 'p1大于p2'; raise exp_difin_error; end if; end; procedure main(p1 in number, p... 阅读全文

摘要： --天select to_char(a.effective_date, 'DD'), sum(a.entered_cr) from gl_je_lines a group by to_char(a.effective_date, 'DD');--月select to_char(a.effective_date, 'MM'), sum(a.entered_cr) from gl_je_lines a group by to_char(a.effective_date, 'MM');--年 select to_char(a.effec 阅读全文

摘要： select df.name 文件名, fs.phyrds 读次数, fs.phywrts 写次数, (fs.readtim / decode(fs.phyrds, 0, -1, fs.phyrds)) 读时间, (fs.writetim / decode(fs.phywrts, 0, -1, fs.phywrts)) 写时间 from v$datafile df, v$filestat fs where df.file# = fs.file# order by df.name 阅读全文

摘要： select substr('1001.2009.233.11.332.1',1,instr('1001.2009.233.11.332.1','.',1,1)-1) from dual; 阅读全文

摘要： SELECT LOCK_INFO.OWNER || '.' || LOCK_INFO.OBJ_NAME AS OBJ_NAME --对象名称(已经被锁住) ,LOCK_INFO.SUBOBJ_NAME AS SUBOBJ_NAME --子对象名称(已经被锁住) ,SESS_INFO.MACHINE AS MACHINE --机器名称 ,LOCK_INFO.SESSION_ID AS SESSION_ID --会话SESSION_ID ,SESS_INFO.SERIAL# AS SERIAL# --会话SERIAL# ,LOCK... 阅读全文

摘要： 1、最常用 1.1直接 v_varchar constant varchar2(30) := 'TEST'; v_number number; v_date date; v_boolean boolean; 1.2复制 v_ord_id ord_sales_order_header.order_id%type; v_number_2 v_number%type; 1.3 行复制 r_ord_table ord_sales_order_header%rowtype;2、复合类型type pl_test is record( segment1 gl_interface.se... 阅读全文

摘要： select to_char(434354.333,'0000000000.00') from dual;结果：0000434354.33 阅读全文