[프로그래머스 - ORACLE] 취소되지 않은 진료 예약 조회하기
CREATE 문 CREATE TABLE PATIENT ( PT_NOVARCHAR(30)NOT NULL, PT_NAMEVARCHAR(30)NOT NULL, GEND_CDVARCHAR(30)NOT NULL, AGENUMBERNOT NULL, TLNOVARCHAR(30)NULL ) CREATE TABLE DOCTOR ( DR_NAMEVARCHAR(30)NOT NULL, DR_IDVARCHAR(30)NOT NULL, LCNS_NOVARCHAR(30)NOT NULL, HIRE_YMDDATENOT NULL, MCDP_CDVARCHAR(30)NULL, TLNOVARCHAR(30)NULL ) CREATE TABLE APPOINTMENT ( APNT_YMDTIMESTAMPNOT NULL, APNT_NOINTEGERNOT..
2023. 3. 23.
