如果你有table：

CREATE TABLE MY_SCHEMA.newtable_test (
  id      VARCHAR2(20),
  counter NUMBER
);

CREATE TABLE A.doc (id, tpid) AS
  SELECT 'abc', 1 FROM DUAL UNION ALL
  SELECT 'abc', 2 FROM DUAL UNION ALL
  SELECT 'def', 1 FROM DUAL;

然后创建程序：

CREATE OR REPLACE PROCEDURE MY_SCHEMA.SDRG (
  ID      IN VARCHAR2,
  COUNTER IN NUMBER
)
IS
BEGIN
    INSERT INTO MY_SCHEMA.newtable_test (ID, COUNTER)
    SELECT doc.ID, doc.TPID FROM A.doc;
END SDRG;
/

然后你可以调用它使用：

BEGIN
  -- The parameters don't do anything and can be random values.
  MY_SCHEMA.SDRG('anything', -42);
END;
/

然后，在调用过程之后，newtable_test将包含：
| 计数器| COUNTER |
| - -----| ------------ |
| 一个| 1 |
| 2| 2 |
| 一个| 1 |
fiddle