SQL

7. 0816_ 프로젝트 관련 sql2

55yudi 2021. 10. 31. 17:22
--DDL Script
--DB Modelng
 -- 테이블, 컬럼을 정하는 작업
 
-- 시퀀스라는 것을 파악하려고 한다.
 create table sample(
  id number(5) primary key,
  name varchar2(100)
);

create sequence sample_seq; --이렇게도 일단 테이블 생성 가능
select sample_seq.nextval from dual;
select sample_seq.currval from dual; --참조

insert into sample(id, name) values(sample_seq.nextval, 'haha');
select * from sample;

--project sql코드----------------
create table member (
  id varchar2(100) primary key,
  pw varchar2(100),
  name varchar2(100),
  age number(30)
);
select * from member;
delete * from member;

create table reservation(
  userId varchar2(100) primary key,
  movie_name varchar2(100),
  movie_date varchar2(100),
  movie_time varchar2(100),
  movie_seat varchar2(100)
);
select * from reservation;