摘要：
SELECT DEPARTMENT_ID, LAST_NAME, SALARY, NTILE(5) OVER(PARTITION BY DEPARTMENT_ID ORDER BY SALARY DESC) AS QUARTILE FROM EMPLOYEES WHERE DEPARTMENT_ID 阅读全文
摘要：
AVG *CORR *COUNT *COVAR_POP *COVAR_SAMP *CUME_DISTDENSE_RANKFIRSTFIRST_VALUE *LAGLASTLAST_VALUE *LEADLISTAGGMAX *MIN *NTH_VALUE *NTILEPERCENT_RANKPERC 阅读全文
摘要：
create sequence seq_test start with 3 increment by 1 minvalue 1 --范围-(1027 -1) maxvalue 999999999999999999999999999 ; --范围1028-1 先 seq_test.nextval ，后 阅读全文
摘要：
ALL If you specify ALL, the default value, then the database evaluates each WHEN clause regardless of the results of the evaluation of any other WHEN 阅读全文
摘要：
TRUNCATE TABLE [schema.] table [ {PRESERVE | PURGE} MATERIALIZED VIEW LOG ] [ {DROP [ ALL ] | REUSE} STORAGE ] ; STORAGE Clauses The STORAGE clauses l 阅读全文
摘要：
CREATE [ SHARED ] [ PUBLIC ] DATABASE LINK dblink [ CONNECT TO { CURRENT_USER | user IDENTIFIED BY password [ dblink_authentication ] } | dblink_authe 阅读全文