SELECT PROFILE.data.cellcode,
       PROFILE.data.code1,
       PROFILE.matrix.customer_id,
       PROFILE.matrix.score
FROM   (( PROFILE.uac
          inner join PROFILE.data
                  ON PROFILE.uac.cellcode = PROFILE.data.cellcode
                     AND PROFILE.uac.code1 = PROFILE.data.code1)
        inner join PROFILE.matrix
                ON ( PROFILE.data.code1 = PROFILE.matrix.code ))
ORDER  BY PROFILE.data.cellcode,
          PROFILE.data.code1 

DROP TABLE PROFILEDB.MATRIX CASCADE CONSTRAINTS;

CREATE TABLE PROFILEDB.MATRIX
(
  CUSTOMER_ID  NUMBER(19)                        NOT NULL,
  CODE   VARCHAR2(192 BYTE)                NOT NULL,
  SCORE       FLOAT(126)                        NOT NULL
)
TABLESPACE USERS
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX PROFILEDB.MATRIX_PK ON PROFILEDB.MATRIX
(CUSTOMER_ID, CODE)
LOGGING
TABLESPACE USERS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

DROP TABLE PROFILEDB.UAC CASCADE CONSTRAINTS;

CREATE TABLE PROFILEDB.UAC
(
  CODE    VARCHAR2(192 BYTE),
  CODE1  VARCHAR2(192 BYTE)
)
TABLESPACE USERS
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;