[Oracle database 11강] - 데이터 조작하기 #1 #2

#1 Insert, Select

안넣은 값들 : NULL 값이 들어갈것임.

insert into member(id, pwd) values('newlac', '111');
insert into member(id, pwd) values('dragon', '111');
select * from member;
select id, name, pwd from member; /* 값 필터링 */
select id as user_id, name, pwd from member;
select id as "user id", name, pwd from member; //빈공백 넣고싶을때

###2. delete, update

update member set pwd='222' where id='newlac';
select * from member;

oracle 서버는 사용자의 접속정보를 따로 관리하고 있음.
접속정보가 다르면 사용자가 다르다고 생각함. == 세션이 다르다.

insert into member(id, pwd) values('test','111');
select id, name, pwd from member;
delete member where id = 'test';