zhouqixin03的博客

?如何使用PL/SQL 合并查询的结果集并用逗号隔开select replace(max(substr(sys_connect_by_path(meaning,','),2)),',',',') ccfrom (select meaning,lead(meaning)over(order by rownum desc) nofrom tableName)connect by prior meaning = nostart with no is null;...

oracle regexp

oracle Partition

oracle user message

可结合excel 产生报表

Oracle 动态sql(二)

动态sql

partition 在oracle db 中的应用

集合：联合数组、嵌套表、可变数组(二）

集合：联合数组、嵌套表、可变数组(一）

oracle db 随机数

循環中continue\標簽\reverse\奇數做級數循環\goto\exit的使用

--多表查詢DROP TABLE DEPT;CREATE TABLE DEPT ( DID VARCHAR2(10) PRIMARY KEY, DEPTNO VARCHAR2(30) NOT NULL, DNAME VARCHAR2(30) NOT NULL, D_PART VARCHAR2(30), MIN_SAR VARCHAR2(30), MAX_SAR VARCHAR2(30) );INSERT ...

DROP TABLE DEPT;CREATE TABLE DEPT ( DID VARCHAR2(10) PRIMARY KEY, DEPTNO VARCHAR2(30) NOT NULL, DNAME VARCHAR2(30) NOT NULL, D_PART VARCHAR2(30), MIN_SAR VARCHAR2(30), MAX_SAR VARCHAR2(30) );INSERT INTO D...

--WITH AS 的用法--创建表CREATE TABLE CHECK_IN(CID NUMBER PRIMARY KEY,CSDATE DATE,CEDATE DATE)SELECT * FROM CHECK_IN;DELETE FROM CHECK_IN;INSERT INTO CHECK_IN VALUES(1,'01-JAN-2021','13-JAN-2021');INSERT INTO CHECK_IN VALUES(2,'13-JAN-2021','13-FEB-2..

--分層查詢/**start with 字段=？；priorconnect bylevel:所在樹的等級（1為根節點）connect_by_isleaf：所在節點是否存在下面其他節點（存在為0，不存在為1，即葉子節點）sys_connect_by_path:拼接siblings：排序**/--樹形查詢create table myemp(eid number(6) primary key,ename varchar2(20) not null,epriorid n...

/**函数**/--大小寫轉換--LOWER小寫、UPPER大寫、INITCAP首字母大寫SELECT LOWER('ADMIN'),UPPER('admin'),INITCAP('iris') FROM DUAL;--字符大小--VSIZESELECT VSIZE('CAT_TOYS') FROM DUAL;--8SELECT VSIZE(NAME) FROM EMP1;--40,當前字段類型為CHAR(40)，CHAR是不可變字符串類型SELECT VSIZE(SYSDATE) FR.

/**表創建表：字段、數據類型、約束、INDEX、表空間、分區等修改表：MODIFY、DROP、ADD**/--删除一个表D_TESTDROP TABLE D_TEST;--創建一個表D_TESTCREATE TABLE D_TEST ( DID VARCHAR2(10) PRIMARY KEY, DNAME VARCHAR2(30) NOT NULL, D_FROM VARCHAR2(30) ) TABLESPACE...