develog

[Oracle] insert all 본문

DB/Oracle

[Oracle] insert all

냐옴 2017. 4. 13. 17:10


INSERT ALL
    INTO AATEST (SEQ, TITLE) VALUES (1, '11')
    INTO AATEST (SEQ, TITLE) VALUES (2, '22')
    INTO AATEST (SEQ, TITLE) VALUES (3, '33')
SELECT 1 FROM DUAL
; 


저작자표시

'DB > Oracle' 카테고리의 다른 글

[Oracle] 컬럼 순서 변경  (0) 2017.04.28
[Oracle] index 비활성  (0) 2017.04.28
[Oracle] total_sec 을 hh:mm:ss 로 변환  (0) 2017.04.04
[Oracle] timestamp to date  (0) 2017.04.03
[Oracle] Function return table  (0) 2017.03.27
'DB/Oracle' Related Articles more
Comments