OracleSQL
오라클 데이터베이스 SQL 강의 10강 - SQL 쿼리 연습을 테이블 준비하기
지각생
2022. 1. 6. 01:21
728x90
CREATE TABLE NOTICE
(
ID NUMBER,
TITLE NVARCHAR2(100),
WRITER_ID NVARCHAR2(50),
CONTENT CLOB,
REGDATE TIMESTAMP,
HIT NUMBER,
FILES NVARCHAR2(1000)
);
CREATE TABLE "COMMENT"
(
ID NUMBER,
CONTENT NVARCHAR2(2000),
REGDATE TIMESTAMP,
WRITER_ID NVARCHAR2(50),
NOTICE_ID NUMBER
);
CREATE TABLE ROLE
(
ID VARCHAR(50),
DESCRIPTION VARCHAR2(500)
);
CREATE TABLE MEMBER_ROLE
(
MEMBER_ID NVARCHAR2(50),
ROLE_ID VARCHAR(50)
);
큰 따옴표로 감싸면 예약어 같은 것도 쓸 수 있다
출처:
https://www.youtube.com/watch?v=ZEW5WY0hxIc&list=PLq8wAnVUcTFVq7RD1kuUwkdWabxvDGzfu&index=10
728x90