CREATE TABLE SRC_TABLE (
  SRCT_ID    VARCHAR2(100 CHAR)
 ,SRCT_NAME  VARCHAR2(500 CHAR) 
 ,SRCT_DESC  VARCHAR2(2000 BYTE) 
)
;
INSERT INTO SRC_TABLE 
SELECT TO_CHAR(LEVEL), 'Name of '||TO_CHAR(LEVEL), 'Description of '||TO_CHAR(LEVEL) 
FROM DUAL CONNECT BY LEVEL <= 10
;
CREATE TABLE TRG_TABLE (
  TRGT_KEY   INTEGER
 ,TRGT_ID    VARCHAR2(100 CHAR)
 ,TRGT_NAME  VARCHAR2(500 CHAR) 
 ,TRGT_DESC  VARCHAR2(2000 BYTE) 
)
;