초보라서 하다하다가 안되서 질문 드려요.
아래는 오라클 페이징 하려는 구문인데요.
2번 구문을 1번 구문에 적용 하려니 잘 안됩니다.고수님들 어떻게 하는지 조언부탁 드려요~~^^
2번 코드를 파란색 글씨쪽에 넣으면 ORA-00918: 열의 정의가 애매합니다. 메세지가 자꾸 뜨네요~~ ㅠㅠㅠ
1)
SELECT * FROM (
SELECT /*+ INDEX_DESC(Z OP_SAMPLE_PK) */ ROWNUM AS RNUM, Z.* FROM (
SELECT * FROM OP_SAMPLE//이곳에 넣으면 될듯
) Z WHERE ROWNUM <= 1000000
) WHERE RNUM >= 999991;
2)
SELECT t500.code code, t500.company_code company_code, t500.trade_date trade_date, t500.trade_type trade_type, t500.payment_yn payment_yn, t500.tax tax,t500.tax_yn tax_yn, t500.total_price total_price, t500.remark remark, nvl(t201.name,'ShoppingMall') name, t211.name employee_name, t261_trk.name trade_type_name, t261_pmy.name payment_yn_name, t201.name, t500.show_yn , to_char(t500.REGIST_DATE_DETAIL,'hh24miss') detail FROM mall_t500_trade t500, mall_t201_company t201, mall_t211_employee t211, (SELECT code, name FROM mall_t261_code t261 WHERE t261.code_kind = 'TRK' AND t261.eprise_code = 0) t261_trk, (SELECT code, name FROM mall_t261_code t261 WHERE t261.code_kind = 'PMY' AND t261.eprise_code = 0) t261_pmy WHERE t500.company_code = t201.code AND t500.payment_yn = t261_pmy.code AND t500.trade_type = t261_trk.code AND t500.regist_code = t211.code AND t500.trade_type like '2%' AND t500.trade_date >= '20150201' AND t500.trade_date <= '20150213' and t500.show_yn = 'Y' AND t500.eprise_code > 0 Order By t500.trade_date desc, t500.code desc