테이블 생성
CREATE TABLE TBS_HEADER_INFORMATION
(
ORG_C CHAR(3)
, HDR_NAME VARCHAR2(60)
, HDR_SEQ NUMBER(3)
, HDR_KR_NAME VARCHAR2(400)
, HDR_LEVEL VARCHAR2(8)
, HDR_FIELD_EN_NM VARCHAR2(60)
, HDR_FIELD_KR_NM VARCHAR2(60)
, HDR_TYPE VARCHAR2(10)
, HDR_ARRY NUMBER(5)
, HDR_ARRY_LEN NUMBER(5)
, HDR_LENGTH NUMBER(5)
, HDR_DOT_LENGTH NUMBER(5)
, HDR_OFFSET NUMBER(5)
, HDR_OPTLEN NUMBER(5)
, HDR_B_OFFSET NUMBER(5)
, HDR_B_OPTLEN NUMBER(5)
, HDR_CNTN VARCHAR(4000)
, LAST_CHNG_MN_USID VARCHAR(14)
, LAST_CHNG_DT VARCHAR(17)
, PRIMARY KEY (ORG_C, HDR_NAME, HDR_SEQ)
);
시노님 생성
CREATE SYNONYM BSHDRI FOR TBS_HEADER_INFORMATION;
