CRUD 연습(+SQL 새 계정 만들기 및 테이블 생성)

CMD 접속

오라클 접속
sqlplus sys/java@localhost:1521 as sysdba

유저생성 
create user 유저명 identified by 비밀번호;

권한부여
grant connect, resource, dba to 유저명;

확인 
select * from all_users;

 

테이블 만들기 

CREATE TABLE MEMBER(
    no number(8) not null,
    id varchar2(100) not null,
    pw varchar2(100) not null,
    name varchar2(100) not null,
    gender varchar2(100) default 'F' null,
    email varchar2(100) default '' null,
    profileimage varchar2(150) default '' null,
    regdate date default sysdate null,
    status varchar2(50) default 'Y' null,
   constraint pk_member primary key(no)
);

 

시퀀스 만들기

CREATE SEQUENCE SEQ_MEMBER
INCREMENT BY 1 START WITH 1 NOCACHE;

 

테스트데이터 

INSERT INTO MEMBER(no,id,pw,name,gender,email,profileimage,regdate,status)
VALUES (SEQ_MEMBER.NEXTVAL,'song','1234','송촌이','F','chonii@naver.com',null,null,null);