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;