Jef_Zhang的博客

一,创建物化视图create materialized view MV_CUST_TACCOINFOrefresh complete on demandstart with to_date('08-05-2020 16:01:00', 'dd-mm-yyyy hh24:mi:ss') next sysdate + 1/(24*60) asSELECT C_CUSTNO, CUST_I...

CREATE OR REPLACE FUNCTION blob_to_clob (blob_in IN BLOB)RETURN CLOBAS     v_clob    CLOB;     v_varchar VARCHAR2(32767);     v_start      PLS_INTEGER := 1;     v_buffer  PLS_INTEGER := 32767;B...