[프로그래머스 - ORACLE] 자동차 대여 기록에서 장기/단기 대여 구분하기
CREATE 문 CREATE TABLE CAR_RENTAL_COMPANY_RENTAL_HISTORY ( HISTORY_IDINTEGER, CAR_IDINTEGER, START_DATEDATE, END_DATEDATE ); INSERT INTO CAR_RENTAL_COMPANY values(1,4,to_date('2022-09-27', 'YYYY-MM-DD'),to_date('2022-11-27','YYYY-MM-DD')) INSERT INTO CAR_RENTAL_COMPANY values(2,3,to_date('2022-10-3', 'YYYY-MM-DD'),to_date('2022-11-04','YYYY-MM-DD')) INSERT INTO CAR_RENTAL_COMPANY values(3,2,to_da..
2023. 3. 20.
[프로그래머스 - ORACLE] 조건에 부합하는 중고거래 댓글 조회하기
CREATE 문 CREATE TABLE USED_GOODS_BOARD ( BOARD_IDVARCHAR2(5), WRITER_IDVARCHAR2(50), TITLEVARCHAR2(100), CONTENTSVARCHAR2(1000), PRICENUMBER, CREATED_DATEDATE, STATUSVARCHAR2(10), VIEWSNUMBER); CREATE TABLE USED_GOODS_REPLY ( REPLY_IDVARCHAR2(10) , BOARD_IDVARCHAR2(5), WRITER_IDVARCHAR2(50), CONTENTSVARCHAR2(1000), CREATED_DATEDATE); SELECT B.TITLE , B.BOARD_ID , R.REPLY_ID, R.WRITER_ID, R.CONTE..
2023. 3. 19.
[DBeaver] Oracle - Join
TABLE 생성 -- 회원 테이블 CREATE TABLE MEMBER ( NAMEVARCHAR2(100) , EMP_NONUMBER PRIMARY KEY, DEPT_NO NUMBER, AGENUMBER, ADDRVARCHAR2(100), REGIST_DATE TIMESTAMP, BIRTH_DAYDATE ) -- 부서 테이블 CREATE TABLE DEPT( DEPT_NONUMBER PRIMARY KEY, DEPT_NAMEVARCHAR2(100), ADDRVARCHAR2(100) ) INSERT * MEMBER INSERT INTO MEMBER(NAME ,EMP_NO ,DEPT_NO,AGE , ADDR , REGIST_DATE ,BIRTH_DAY) VALUES('white' ,1000 ,100,1 , '대..
2023. 3. 19.
