■[SQL 7_1_1] Total 레코드 수 SELECT
SELECT  COUNT(*) totcnt
FROM  INSA_BBS
WHERE  BBS_CODE = #bbsCode#;

■[SQL 7_1_2] 게시판 시작 페이지와 CountperPage 입력
SELECT A.BBS_CODE bbsCode,
         A.BBS_SEQ bbsSeq,
         A.TITLE title,
  A.CONTENT content,
  A.ID id ,
      A.PW pw ,
      A.BBS_DATE bbsDate ,
      A.HIT_CNT hitCnt ,
  A.NAME name
FROM INSA_BBS A
WHERE 1=1____
AND A.BBS_CODE = #bbsCode#
ORDER BY BBS_SEQ DESC
LIMIT #firstIndex#, #pageUnit#;

■예 7_2_1  ||  대용량 DB의 페이징 처리1
SELECT BBS_SEQ, TITLE, NAME, WRITE_DATE, HIT_CNT
FROM  BOARD
WHERE BBS_SEQ > :T_BBS_SEQ
AND ROWNUM <= 10
AND :SW  = 'D'
UNION
SELECT /*+ INDEX_DESC(BOARD BOARD _PK) */
BBS_SEQ, TITLE, NAME, WRITE_DATE, HIT_CNT
FROM BOARD
WHERE BBS_SEQ < :F_BBS_SEQ
AND ROWNUM <= 10
AND :SW  = 'U';

■예 7_2_2  ||  대용량 DB의 페이징 처리2
SELECT SABUN, NAME, HP, YEARS, SEX, CARRIER, POS_GBN_CODE, ADDR1||ADDR2, PUT_YN
FROM  INSA
WHERE SABUN > :T_SA