NAME_ID列是NULL，表table13_prc中的NAME_ID是外键，表table_prc4中的ID是主键。我想在NAME_ID列中输出来自table_prc4的id的令牌。
我的代码是：

Create Table table13_prc (
                          Family    VARCHAR2(200),
                          Name      VARCHAR2(200) ,
                          ID        INTEGER  NOT NULL PRIMARY KEY ,
                          NAME_ID   INTEGER  REFERENCES TABLE_PRC4(id)
                          ) ;
                                                   
CREATE SEQUENCE ID_seq5
  MINVALUE 1
  START WITH 1
  INCREMENT BY 1 ;
   
Create or Replace trigger trg5 
  BEFORE insert on  table13_prc 
   for each row 
   BEGIN
   select ID_seq5.nextval INTO :new.ID from dual ;
   END ;
 
CREATE OR REPLACE PROCEDURE addnewmem6 (str IN VARCHAR2)
   AS
    BEGIN
      INSERT INTO table13_prc (Name, Family)
          WITH
            temp
             AS
               (    SELECT REGEXP_SUBSTR (str,
                                           '[^,]+',
                                          1,
                                        LEVEL) val
                    FROM DUAL
               CONNECT BY LEVEL <= REGEXP_COUNT (str, ',') + 1)
         SELECT TRIM(SUBSTR(val, 1, INSTR (val, ';') - 1)),
               TRIM(SUBSTR(val, INSTR (val, ';') + 1))
          FROM temp;
 
      COMMIT;
   END;
 
CREATE OR REPLACE PROCEDURE delete_member2 (par_id IN VARCHAR2)
IS
BEGIN
   DELETE FROM table13_prc
         WHERE id = par_id;
END;

BEGIN
  addnewmem6 ('faezeh;Ghanbarian,pari;izadi');
END;
    
BEGIN
  addnewmem6 ('Saeed;Izadi,Saman; Rostami');
END; 
    
BEGIN
  delete_member2 (1);
END;
 
BEGIN
  delete_member2 (2) ;
END;
 
CALL delete_member2(5);
 
CALL delete_member2(66);

   
select *
from  table13_prc ;

我想在输出中，列NAME_ID不是null，我想在NAME_ID中取table_prc4中的id。