IngThread

INSERT INTO COMPANY( COMPANY_NO , COMPANY_GUBUN , CRD_DT , COMPANY_CODE , COMPANY_NM ) SELECT COMPANY_SEQ.NEXTVAL AS COMPANY_NO , '1' AS COMPANY_GUBUN , SYSDATE AS CRD_DT , A.COMPANY_CODE , A.COMPANY_NM FROM ( SELECT SUBSTR(PUB_CD,3,4) AS COMPANY_CODE ,PUB_NM AS COMPANY_NM FROM TEXTBOOK GROUP BY PUB_CD,PUB_NM ORDER BY PUB_CD ASC ) A 설명 : TEXTBOOK에 INSERT 된 PUB_CD(기관코드),PUB_NM(기관명) GROUP BY 해서 조회..

DBMS/Oracle 2012. 11. 14. 11:56

SQL 오류: ORA-01830: 날짜 형식의 지정에 불필요한 데이터가 포함되어 있습니다------------------------------------------------------------------------------------년월일시분초 select to_timestamp('20121108101010') from dual;result : 2012-11-08 10:10:10.00000000초다음 0.1초 넣을시select to_timestamp('20121108101010.1') from dual;result : error이럴시 데이터포멧을 넣는다.select to_timestamp('20121108101010.1','yyyymmddhh24missff') from dual;.을 넣을시 같이넣어..

DBMS/Oracle 2012. 11. 8. 12:01