시간표 쿼리를 짜려고 하는데 검색을 하니까 하나 있긴 한데

제가 응용하기엔 실력이 안되서...

LECTURE(테이블)

L_CODE

R_CODE

USER_ID

L_NAME

L_START

L_END

L_DAY

L_TIME

L_DETAIL

L_PAY

PAY_CHECK

REG_USER

REG_DT

U_USER

U_DATE

여기에 필요한 데이터를 불러와서

요런식으로 데이터를 가져 오고 싶은데 쿼리를 어케 짜야 할지 모르겠네요

도와주세요 ㅠ

CREATE TABLE "FLASHMAN"."LECTURE" 
   (    "L_CODE" VARCHAR2(10 BYTE) NOT NULL ENABLE, 
    "R_CODE" VARCHAR2(10 BYTE) NOT NULL ENABLE, 
    "USER_ID" VARCHAR2(10 BYTE) NOT NULL ENABLE, 
    "L_NAME" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
    "L_START" DATE NOT NULL ENABLE, 
    "L_END" DATE NOT NULL ENABLE, 
    "L_DAY" VARCHAR2(5 BYTE) NOT NULL ENABLE, 
    "L_TIME" VARCHAR2(10 BYTE) NOT NULL ENABLE, 
    "L_DETAIL" CLOB NOT NULL ENABLE, 
    "L_PAY" NUMBER NOT NULL ENABLE, 
    "PAY_CHECK" CHAR(1 BYTE) DEFAULT 0 NOT NULL ENABLE, 
    "REG_USER" VARCHAR2(10 BYTE) NOT NULL ENABLE, 
    "REG_DT" DATE DEFAULT SYSDATE, 
    "U_USER" VARCHAR2(10 BYTE), 
    "U_DATE" DATE DEFAULT SYSDATE, 
     CONSTRAINT "PK_LECTURE" PRIMARY KEY ("L_CODE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "FLASHMAN_TBS"  ENABLE, 
     CONSTRAINT "FK_MEMBER_TO_LECTURE" FOREIGN KEY ("USER_ID")
      REFERENCES "FLASHMAN"."MEMBER" ("USER_ID") ENABLE, 
     CONSTRAINT "FK_ROOM_TO_LECTURE" FOREIGN KEY ("R_CODE")
      REFERENCES "FLASHMAN"."ROOM" ("R_CODE") ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "FLASHMAN_TBS" 
 LOB ("L_DETAIL") STORE AS BASICFILE (
  TABLESPACE "FLASHMAN_TBS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION 
  NOCACHE LOGGING 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
 

   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_CODE" IS '강의코드';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."R_CODE" IS '강의실코드';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."USER_ID" IS '강사아이디';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_NAME" IS '강의이름';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_START" IS '강의시작일';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_END" IS '강의종료일';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_DAY" IS '강의요일';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_TIME" IS '강의시간';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_DETAIL" IS '강의정보';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."L_PAY" IS '수강료';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."PAY_CHECK" IS '급여지불확인';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."REG_USER" IS '등록자';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."REG_DT" IS '등록일';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."U_USER" IS '수정자';
 
   COMMENT ON COLUMN "FLASHMAN"."LECTURE"."U_DATE" IS '수정일';
 
   COMMENT ON TABLE "FLASHMAN"."LECTURE"  IS '강의';