Oracle 페이징,리스팅,인덱스
게시판 페이징.. : -> rownum $cfg->postnum=10; $page = 1; SELECT cn_num, cn_kind, cn_title,cn_contents, cn_cnt,to_char(cn_inputdate,'yyyy/mm/dd'), cn_use FROM (SELECT /*+index_desc(cn_announce_cn_num_pk)*/ rownum as rnum, cn_num, cn_kind, cn_title,cn_contents, cn_cnt,cn_inputdate, cn_use FROM (SELECT cn_num, cn_kind, cn_title,cn_contents, cn_cnt,cn_inputdate, cn_use FROM cs_announce ORDER BY cn_num des..
2007. 10. 22.