데이터베이스/Oracle

Oracle 테이블에 데이터 추가

왕왕왕왕 2015. 8. 20. 15:20

insert into 테이블명(삽입할 컬럼명.....)  values(컬럼에 넣을값....)


insert into test(id,username,dept,birth,email) values(1,'king','a','1988-11-01','c')


insert into test(id,username,dept,birth,email) values(2,'king1','a1','1988-11-02','c1')


insert into test(id,username,dept,birth,email) values(3,'king2','a2','1988-11-03','c2')