SQL> desc LIDTNOAOBUNMSRCH ; 이름 널? 유형 ----------------------------------------- -------- ------------------------ APV_PERM_NO NOT NULL VARCHAR2(19) SRCH_YMD NOT NULL CHAR(8) TRNM VARCHAR2(255) OAO_COB_CODE CHAR(2) OAO_TELNO VARCHAR2(20) ADVO_SORT_CODE CHAR(2) LGHT_SR_CODE VARCHAR2(2) ADVO_SIZE VARCHAR2(100) ADVO_WIDTH_LT NUMBER(12,2) ADVO_HEIGTH_LT NUMBER(12,2) ADVO_HG NUMBER(12,2) ADVO_SRFC NUMBER(12,2) UNIT_CODE VARCHAR2(3) BUPD_CODE CHAR(10) MANIF_BUNJI VARCHAR2(20) MANIF_HO VARCHAR2(4) UMD_CODE CHAR(7) MANIF_ST_YMD CHAR(8) ADVO_PERM_NT_NO VARCHAR2(19) PERM_YMD CHAR(8) XPIRE_YMD CHAR(8) ADV_CN VARCHAR2(2000) SANGGA_AND_BDNG_NM VARCHAR2(60) SFT_DGR_ISP_YMD CHAR(8) OAB_TRNM_NM VARCHAR2(60) OAB_REPSNT_NM VARCHAR2(60) OAB_TELNO VARCHAR2(20) RD_ITFEC_YN CHAR(1) RD_ITFEC_WIDTH NUMBER(6,2) RD_ITFEC_HEIGTH NUMBER(6,2) PERM_YN_CODE CHAR(2) PLC_CB_SITU_CODE CHAR(2) KD_CB_SITU_CODE CHAR(2) ETC_SE_CODE CHAR(1) ETC_YMD CHAR(8) WRN_CHASU NUMBER(2) INIT_DATA_SE CHAR(1) FRST_REG_TS DATE FRST_REGR_ID VARCHAR2(20) LAST_MOD_TS DATE LAST_CORT_ID VARCHAR2(20) APV_PERM_MGT_NO VARCHAR2(20) ESB_PLC VARCHAR2(200) BDNG_NM VARCHAR2(100) MANIF_SAN CHAR(1) MANIF_TONG VARCHAR2(3) MANIF_BAN VARCHAR2(3) MANIF_SPEC_ADDR VARCHAR2(90) MANIF_SPEC_DNG VARCHAR2(20) MANIF_SPEC_HO VARCHAR2(10) PHOTO BLOB PHOTO_ROUTE VARCHAR2(200) PHOTO_WHL BLOB PHOTO_INDI BLOB PHOTO_DETAIL BLOB ADVP_NM VARCHAR2(60) STATE_SE CHAR(1) SID VARCHAR2(13) SID_SNO VARCHAR2(3) REGN_CODE CHAR(10) SAN CHAR(1) BUNJI VARCHAR2(20) HO VARCHAR2(4) TONG VARCHAR2(3) BAN VARCHAR2(3) SPEC_ADDR VARCHAR2(90) SPEC_DNG VARCHAR2(20) SPEC_HO VARCHAR2(10) ADVP_UMD_CODE CHAR(7) SQL>