CREATE OR REPLACE PROCEDURE P_DATA_SYNC
AS
CURSOR ins_table
IS
SELECT 'INSERT INTO '
|| t.table_name
|| ' (SELECT * FROM '
|| t.table_name
|| ' WHERE SYNC_FG = 0)' sqlstmt
FROM user_tables t;
BEGIN
FOR c1 IN ins_table
LOOP
EXECUTE IMMEDIATE (c1.sqlstmt);
END LOOP;
END;
AS
CURSOR ins_table
IS
SELECT 'INSERT INTO '
|| t.table_name
|| ' (SELECT * FROM '
|| t.table_name
|| ' WHERE SYNC_FG = 0)' sqlstmt
FROM user_tables t;
BEGIN
FOR c1 IN ins_table
LOOP
EXECUTE IMMEDIATE (c1.sqlstmt);
END LOOP;
END;

কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন