MEMBER 테이블 - DML ( insert , update , delete , select ) > ORACLE

• 목록

insert into member(id,pass) values('1111','1111');

select * from member; 

insert into member(id,pass) values('2222','2222');

select * from member; 

update member set pass='3333' where id='2222';

select * from member; 

delete from member where id='2222';

select * from member;

commit; //영구 저장되는 영역에 저장

<!-- INSERT -->

01. insert into 테이블명 ( 원하는 칼럼들 ) values ( 해당 칼럼에 해당하는 값들 - 순차적으로 매칭 );

ex) insert into member (id,pass) values ('1111','1111'); //위 예제 인용

02. insert into 테이블명 values ( 모든 칼럼에 해당하는 값들 ); //칼럼 생략

insert into member values('2222','2222','이순이','F','2002-01-01','010-2222-2222','2023-03-01','2222@2222.com'); //실행

<!-- SELECT --> 

03. select * from member; //실행

04. select id,pass from member; //실행 

<!-- UPDATE --> 

05. update member set name='일돌이',email='1111@1111.com' where id='1111'; //실행

06. select * from member; //실행 

07. commit; //영구 저장되는 영역에 저장