`
文章列表
----------------------------------------------------------------------- --生成id的方式1,创建序列: create sequence tmp_id increment by 1 start with 1 maxvalue 9999999 nocycle nocache; tmp_id.nextval   2,使用uuid:SYS_GUID(); example: create table as select tmp_id.nextval as id,trunc(DBMS_RANDOM.VALUE(2 ...
oralce 视图:   物化视图----1,创建物化视图; CREATE MATERIALIZED VIEW V_MATERIAL_INVEST REFRESH FORCE ON DEMAND AS DBMS_MVIEW.REFRESH('V_BB_GETTWO');  2,存储过程里-刷新物化视图   DBMS_MVIEW.REFRESH('V_BB_GETTWO');  
Select to_char(sysdate,'yYmm') from dual; --几个y都可以的 Select to_char(sysdate,'Q') from dual; --季度 Select to_char(sysdate,'Month') from dual; --中文月份 Select to_char(sysdate,'WW') from dual; --WW 当年第几周(2007年第22周) Select to_char(sysdate,'W') from dual; --W本月第几周 (5月第5周) Select to_char(sy ...
Global site tag (gtag.js) - Google Analytics