LOB類型的字段由lob segment和lob index segment組成 对存储在lob data segment中lob 数据的访问,都需要先根据lob locator访问lob index,再访问lob data segment lob segment使用:1. DISABLE STORAGE IN ROW2. ENABLE STORAGE IN ROW ...【阅读全文】
select name,value from v$sysstat where name like 'parse%';我的方法找出多次沒有綁定變量的sql:select count exe_count,module,SQL_TEXT from (select ROW_NUMBER()over(partition by substr(SQL_TEXT,1,50) order by SQL_TEXT) num,a.* from (select count(*)over(partition by substr(SQL_TEXT,1,50)) count ,SQL_TE...【阅读全文】
1.替代变量:select * from emp where sal>&put;范例:查询一个雇员编号、姓名、职位、雇佣日期、基本工资,查询的雇员姓名,由用户输入select empno,ename,job,hiredate,sal from emp where ename=upper('&name');范例:根据雇员姓名的关键字(由用户输入)查询雇员编号、姓名、职位、雇佣日期、基本工资。select e...【阅读全文】
----查询预占with InventoryHoldings as (select d.branchid,d.prodid,d.storeid,sum(decode(d.custid,'DWI00028537',1,0)) isCust,--开票抬头的单位内码 sum(d.QUANTITY) as keepqtysum from TB_GOS_BUSI_STOCKRETAINDET d...【阅读全文】