ITPub博客

两个查询出来的结果一样吗？理解exists的判断条件。select 1from dual dwhere exists(select 1from dual d2where d.DUMMY=d2.DUMMYand 1=2)/select 1from dual dwhere exists(select count(*)from dual d2where d.D...

游标死循环：报错信息：EDU.PROC_A:ORA-01000: maximum open cursors exceeded ORA-06512: at "EDU.PROC_A", line 29 ORA-01000: maximum open cursors exceeded ORA-06512: at "EDU.PROC_A", line 25 ORA-01000: ...

内容为：id       content1        读书《读《家》有感》以及《雷雨》等等2        读书《呐喊》和《边城》等等3   &n...

 一、add_months在月末时看看两者语句是否一个意思呢？？？结果呢？？？？？select add_months(add_months(to_date('20120130','yyyymmdd'),1),1) from dual2012-3-31 00:00:00.000select  add_mont...

--随机排序SELECT *FROM (select level from dual connect by level<10)ORDER BY DBMS_RANDOM.VALUE--order by的数字比列数大：SELECT *FROM (select level from dual connect by level<10)ORDER BY 2ORA-01785:ORD...

SELECT       CASE       WHEN ATTIME>=TO_DATE('20111201','YYYYMMDD') AND ATTIME<TO_DATE('20111208','YYYYMMDD') THEN 1       WH...

工作中遇到问题：分页查询两个页面查询的数据一样，select * from    (    select rownum as rw,a1.*     from (         ........

--一、建立测试表CREATE TABLE T11(ID INT , NAME VARCHAR2(1000));/CREATE TABLE T21(ID INT , NAME CHAR(1000));/BEGIN    FOR I IN 1..10000 LOOP    INSERT INTO T11 VALUES(I,sy...

drop table t;--建表create table t ( x int );--存储过程1 绑定变量create or replace procedure proc1asbegin    for i in 1 .. 10000    loop     &nbsp...

create table test (a int);/CREATE OR REPLACE PROCEDURE mytestASBEGIN   --启动profiler  sys.DBMS_PROFILER.start_profiler ('xx');   FOR I IN 1 .. 100   LOOP &nbsp...

EXAMPLE: Creating an External Table and Loading DataThe file empxt1.dat contains the following sample data:360,Jane,Janus,ST_CLERK,121,17-MAY-2001,3000,0,50,jjanus361,Mark,Jasper,SA_REP,145,17-MAY-20...

WITHAAS(SELECT 1 ID FROM DUAL---一条记录),BAS(SELECT 2 ID FROM DUAL WHERE ROWNUM<1--没有记录)SELECT A.ID,B.IDFROM A,BWHERE B.ID(+)=3

merge 源表违反唯一性约束/oracle unable to get a stable set of rows in the source tables源表不能有重复行

--创建同义词FOR ClauseSpecify the object for which the synonym is created. The schema object for which you are creating the synonym can be of the following types:Table or object tableView or object...

withaas (select 1 id,'NAME1'   name            ,0  pid from dualunion allselect 2 ,'NAME2'           &nbs...

CREATE OR REPLACE PACKAGE EASTERISTYPE T IS TABLE OF VARCHAR2(9) INDEX BY BINARY_INTEGER;S T;D T;E T;N NUMBER;A NUMBER;B NUMBER;Q NUMBER;M NUMBER;W NUMBER;P NUMBER;C NUMBER;PROCEDURE SHOWALLEASTERDAY...

select * from v$sql where hash_value in (select sql_hash_value from v$session where sid in(select session_id from v$locked_object))

oracle10g中行转列比较麻烦，需要写很多个decode，在11g中使用以下语法就可以行转列、列转行，测试语句如下：--行转列withaas(select '4_20110417' ci,'A' ab,1 num from dualunion&n...

1,2,3,4,5,6 任意组合相乘，求最大数withaas(select to_char(rownum) num1from dualconnect by rownum<=6),b(num1 ,num2,num3 )as(select a.num1 num1,a.num1 num2,1 num3from aunion allselect a.num1 num1,b.num2...

/**解题思路：题目需要求解按照公司、服务、当天人数来计算费用。*为了减少记录数，不按照每天一计算，按照一段时间计算的方式求解。*比如：在1号到5号某个公司、服务的人数都是一样的，那么记录一条记录即可。公司...