[프로그래머스 - 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.