빅데이터정보 썸네일형 리스트형 테라스트림(TeraStream)에서 테이블 정보확인 TERA_UNLOAD_INFO TERA_UNLOAD_INFOselect a.prj_grp_id , a.nm as prj_name , c.nm as block_name , b.outfile1 , b.type , b.delim , b.field5 , d.nm as ffd_name , d.table_nm as ffd_table_nm , d.sfiller1 as path_ffd , e.nm as ffd_col_name , e.col_data_type_cd , e.col_sep , e.col_loc , e.col_size , e.prec , e.table_field_type , e.table_field_name , e.table_precision , e.table_scale , e.table_PK_nullability -- 0:nullable.. 더보기 테라스트림(TeraStream)에서 테이블 정보확인 TERA_LOAD_INFO TERA_LOAD_INFOselect a.prj_grp_id , a.nm as prj_name , b.log_file as ctl_log_file , b.bad_file as ctl_bad_file , b.data_file as ctl_data_file , b.load_type_cd as ctl_load_type_cd -- 1:APPEND,2:TRUNCATE , c.nm as ffd_name , c.table_nm as ffd_table_nm , c.sfiller1 as path_ffd , d.nm as ffd_col_name , d.col_data_type_cd , d.col_sep , d.col_loc , d.col_size , d.prec , d.table_field_type , d.table_fi.. 더보기 ERD기준으로 테이블생성하기- ERWin 개발을 하다보면 당연히 접하게 되는 ERWinERWin에서 테이블을 생성하는 방법- ERWin 실행- Tools -> Forward Enginner -> Schema Generation 선택- 생성할 것들만 체크 -> Preview SELECT A.*FROM CONVDBA.TOBE_TABLE_MAP AWHERE 1=1AND CONV_YN = 'Y'AND SUBSTR(E_TABLE_NAME_TOBE,1,1) IN ('A','M','S','G','C')AND EXISTS (SELECT 1 FROM (SELECT DISTINCT E_TABLE_NAME_TOBE FROM CONVDBA.TOBE_TABLE_MAP A , DBA_OBJECTS B WHERE 1=1 AND A.E_TABLE_NAME_TOBE = B... 더보기 이전 1 2 다음 목록 더보기