create temp table and insert data in pl/sql | Oracle Solved

create temp table and insert data in pl/sql | Oracle Solved

瀏覽:376
日期:2025-10-04
EXECUTE IMMEDIATE ' CREATE TABLEA (BATCH_ID NUMBER, CLM_ID NUMBER, PROC_CD VARCHAR2(15));'; INSERT INTO TABLEA SELECT BATCHID, CLM_ID, PROC_CD FROM TABLEB WHERE PROC_CD = 'ABC'; UPDATE TABLEC C SET MODF ......看更多