oracle自关联

自关联脚本留备忘

Drop Table TBL80064;

 CREATE TABLE TBL80064(UNIT_CODE VARCHAR2(20) NOT NULL
               ,ITEM_CODE VARCHAR2(20) NOT NULL
               ,SHOP_CODE VARCHAR2(7) NOT NULL
               ,RECEIPT_RATE_CODE NUMBER(5)
               ,COMBINED_SHOP_CODE VARCHAR2(7)
               ,CONSTRAINT CST80064PK PRIMARY KEY(UNIT_CODE, ITEM_CODE));

INSERT INTO TBL80064
  (UNIT_CODE
  ,ITEM_CODE
  ,SHOP_CODE
  ,RECEIPT_RATE_CODE
  ,COMBINED_SHOP_CODE)
VALUES
  ('00000002'
  ,'00000038'
  ,'5071503'
  ,'10001'
  ,NULL);
INSERT INTO TBL80064
  (UNIT_CODE
  ,ITEM_CODE
  ,SHOP_CODE
  ,RECEIPT_RATE_CODE
  ,COMBINED_SHOP_CODE)
VALUES
  ('00000003'
  ,'00000039'
  ,'5071504'
  ,'10002'
  ,NULL);
INSERT INTO TBL80064
  (UNIT_CODE