사용자 만들기와 권한
CREATE USER java IDENTIFIED BY java;
GRANT CONNECT, RESOURCE, CREATE VIEW TO java;
회원 관리 테이블 생성
CREATE TABLE member(
id VARCHAR2(20) PRIMARY KEY,
name VARCHAR2(30) NOT NULL,
age NUMBER(3),
tel VARCHAR2(13) );
SELECT * FROM tab;
SELECT * FROM member;
데이터 넣기와 COMMIT
INSERT INTO member (id,name,age,tel)
VALUES('admin','이영환','56','010-6000-5000');
COMMIT;
INSERT INTO member (id,name,age,tel)
VALUES('test','홍길동','27','010-1111-1234');
COMMIT;
INSERT INTO member (id,name)
VALUES('kim','김유신');
COMMIT;
SELECT id,name,age,tel FROM member;
데이테 수정, 삭제, COMMIT, ROLLBACK
DELETE FROM member;
SELECT * FROM member;
ROLLBACK;
UPDATE member SET age = 50 WHERE id ='kim';
COMMIT;
UPDATE member SET age = age + 1;
COMMIT;