ORACLE SQL.CTL 파일 문자열 잘라 insert 하기
LOAD DATA INFILE '파일명' insert INTO TABLE TRANSDATA ( pos_no POSITION(002:016), sale_date POSITION(017:024), sale_time POSITION(025:030), sale_no POSITION(031:042), access_yn POSITION(043:044), card_no POSITION(045:060), ori_sale_date POSITION(061:068), appr_no POSITION(069:078), appr_amt POSITION(079:090), service_amt POSITION(091:099), vat_amt POSITION(100:108), installment POSITION(109:110), c..
더보기
Oracle Shared Pool
SHARED_POOL select sql_text ,version_count ,loads ,invalidations ,parse_calls ,sorts from v$sqlarea where command_type in (2,3,6,7) order by first_load_time desc,sql_text; sql_text version_count loads invalidations parse_calls sorts ---------------------------------------------------------------------------------------------------- select ename, sal from myemp order by job, ename 1 1 0 1 1 selec..
더보기