GlroyFuture的专栏

SELECT DRG, COUNT( 1 ) CASE_CNT, AVG( FEE ), DEDIAN (FEE ), PERCENTILE_DISC(0.25) WITHIN GROUP(ORDER BY FEE ASC) P25, -- Q1 PERCENTILE_DISC(0.5) WITHIN GROUP( ORD...

线性拟合度 REGR_R2(FEE, IN_DAY);截距 REGR_INTERCEPT(FEE, IN_DAY);斜率 REGR_SLOPE(FEE, IN_DAY);

MULTISET UNION:取得两个嵌套表的并集 结果集中会包含重复值，不去重；MULTISET UNION DISTINCT: 取得两个嵌套表的并集 并取消重复结果,去重；MULTISET INTERSECT:用于取得两个嵌套表的交集；NULTISET EXCEPT:用于取得两个嵌套表的差集 在A集合中存在,但在B集合中不存在。...

方法一create database link RT_DATAconnect to DRGVIEW identified by dhccusing '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME =ORACLE)))'...

1 ) insert /*+ append */ into tab1 select * from hyper;2) 减少 COMMIT 的次数3) alter table tab1 nologging; alter table tb1logging;4) INSERT ALL INTO TABLE_A(A,B) VALUES(1,2)INTO TABLE_...

create or replace type DIAG as object( DIAG_TYPE VARCHAR2(50), C03C VARCHAR2(20), C04N VARCHAR(200), C05C VARCHAR(20));create or replace type DIAG_TAB as table of DIAG;create or r...