오라클 데이터베이스 SQL 강의 10강 - SQL 쿼리 연습을 테이블 준비하기
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_I..
2022. 1. 6.