CREATE TABLE PAGE_TABLE (
"IDX" NUMBER,
"TITLE" VARCHAR2(100),
"CONTENT" VARCHAR2(200)
) ;
INSERT INTO page_table VALUES(0, '제목_0','내용내용내용내용:0');
INSERT INTO page_table VALUES(1, '제목_1','내용내용내용내용:1');
INSERT INTO page_table VALUES(2, '제목_2','내용내용내용내용:2');
INSERT INTO page_table VALUES(3, '제목_3','내용내용내용내용:3');
INSERT INTO page_table VALUES(4, '제목_4','내용내용내용내용:4');
INSERT INTO page_table VALUES(5, '제목_5','내용내용내용내용:5');
INSERT INTO page_table VALUES(6, '제목_6','내용내용내용내용:6');
INSERT INTO page_table VALUES(7, '제목_7','내용내용내용내용:7');
INSERT INTO page_table VALUES(8, '제목_8','내용내용내용내용:8');
INSERT INTO page_table VALUES(9, '제목_9','내용내용내용내용:9');
INSERT INTO page_table VALUES(10, '제목_10','내용내용내용내용:10');
INSERT INTO page_table VALUES(11, '제목_11','내용내용내용내용:11');
INSERT INTO page_table VALUES(12, '제목_12','내용내용내용내용:12');
INSERT INTO page_table VALUES(13, '제목_13','내용내용내용내용:13');
INSERT INTO page_table VALUES(14, '제목_14','내용내용내용내용:14');
INSERT INTO page_table VALUES(15, '제목_15','내용내용내용내용:15');
INSERT INTO page_table VALUES(16, '제목_16','내용내용내용내용:16');
INSERT INTO page_table VALUES(17, '제목_17','내용내용내용내용:17');
INSERT INTO page_table VALUES(18, '제목_18','내용내용내용내용:18');
INSERT INTO page_table VALUES(19, '제목_19','내용내용내용내용:19');
INSERT INTO page_table VALUES(20, '제목_20','내용내용내용내용:20');
INSERT INTO page_table VALUES(21, '제목_21','내용내용내용내용:21');
INSERT INTO page_table VALUES(22, '제목_22','내용내용내용내용:22');
INSERT INTO page_table VALUES(23, '제목_23','내용내용내용내용:23');
INSERT INTO page_table VALUES(24, '제목_24','내용내용내용내용:24');
INSERT INTO page_table VALUES(25, '제목_25','내용내용내용내용:25');
INSERT INTO page_table VALUES(26, '제목_26','내용내용내용내용:26');
INSERT INTO page_table VALUES(27, '제목_27','내용내용내용내용:27');
INSERT INTO page_table VALUES(28, '제목_28','내용내용내용내용:28');
INSERT INTO page_table VALUES(29, '제목_29','내용내용내용내용:29');
INSERT INTO page_table VALUES(30, '제목_30','내용내용내용내용:30');
INSERT INTO page_table VALUES(31, '제목_31','내용내용내용내용:31');
INSERT INTO page_table VALUES(32, '제목_32','내용내용내용내용:32');
INSERT INTO page_table VALUES(33, '제목_33','내용내용내용내용:33');
INSERT INTO page_table VALUES(34, '제목_34','내용내용내용내용:34');
INSERT INTO page_table VALUES(35, '제목_35','내용내용내용내용:35');
INSERT INTO page_table VALUES(36, '제목_36','내용내용내용내용:36');
INSERT INTO page_table VALUES(37, '제목_37','내용내용내용내용:37');
INSERT INTO page_table VALUES(38, '제목_38','내용내용내용내용:38');
INSERT INTO page_table VALUES(39, '제목_39','내용내용내용내용:39');
INSERT INTO page_table VALUES(40, '제목_40','내용내용내용내용:40');
INSERT INTO page_table VALUES(41, '제목_41','내용내용내용내용:41');
INSERT INTO page_table VALUES(42, '제목_42','내용내용내용내용:42');
INSERT INTO page_table VALUES(43, '제목_43','내용내용내용내용:43');
INSERT INTO page_table VALUES(44, '제목_44','내용내용내용내용:44');
INSERT INTO page_table VALUES(45, '제목_45','내용내용내용내용:45');
INSERT INTO page_table VALUES(46, '제목_46','내용내용내용내용:46');
INSERT INTO page_table VALUES(47, '제목_47','내용내용내용내용:47');
INSERT INTO page_table VALUES(48, '제목_48','내용내용내용내용:48');
INSERT INTO page_table VALUES(49, '제목_49','내용내용내용내용:49');
INSERT INTO page_table VALUES(50, '제목_50','내용내용내용내용:50');
INSERT INTO page_table VALUES(51, '제목_51','내용내용내용내용:51');
INSERT INTO page_table VALUES(52, '제목_52','내용내용내용내용:52');
INSERT INTO page_table VALUES(53, '제목_53','내용내용내용내용:53');
INSERT INTO page_table VALUES(54, '제목_54','내용내용내용내용:54');
INSERT INTO page_table VALUES(55, '제목_55','내용내용내용내용:55');
INSERT INTO page_table VALUES(56, '제목_56','내용내용내용내용:56');
INSERT INTO page_table VALUES(57, '제목_57','내용내용내용내용:57');
INSERT INTO page_table VALUES(58, '제목_58','내용내용내용내용:58');
INSERT INTO page_table VALUES(59, '제목_59','내용내용내용내용:59');
INSERT INTO page_table VALUES(60, '제목_60','내용내용내용내용:60');
INSERT INTO page_table VALUES(61, '제목_61','내용내용내용내용:61');
INSERT INTO page_table VALUES(62, '제목_62','내용내용내용내용:62');
INSERT INTO page_table VALUES(63, '제목_63','내용내용내용내용:63');
INSERT INTO page_table VALUES(64, '제목_64','내용내용내용내용:64');
INSERT INTO page_table VALUES(65, '제목_65','내용내용내용내용:65');
INSERT INTO page_table VALUES(66, '제목_66','내용내용내용내용:66');
INSERT INTO page_table VALUES(67, '제목_67','내용내용내용내용:67');
INSERT INTO page_table VALUES(68, '제목_68','내용내용내용내용:68');
INSERT INTO page_table VALUES(69, '제목_69','내용내용내용내용:69');
INSERT INTO page_table VALUES(70, '제목_70','내용내용내용내용:70');
INSERT INTO page_table VALUES(71, '제목_71','내용내용내용내용:71');
INSERT INTO page_table VALUES(72, '제목_72','내용내용내용내용:72');
INSERT INTO page_table VALUES(73, '제목_73','내용내용내용내용:73');
INSERT INTO page_table VALUES(74, '제목_74','내용내용내용내용:74');
INSERT INTO page_table VALUES(75, '제목_75','내용내용내용내용:75');
INSERT INTO page_table VALUES(76, '제목_76','내용내용내용내용:76');
INSERT INTO page_table VALUES(77, '제목_77','내용내용내용내용:77');
INSERT INTO page_table VALUES(78, '제목_78','내용내용내용내용:78');
INSERT INTO page_table VALUES(79, '제목_79','내용내용내용내용:79');
INSERT INTO page_table VALUES(80, '제목_80','내용내용내용내용:80');
INSERT INTO page_table VALUES(81, '제목_81','내용내용내용내용:81');
INSERT INTO page_table VALUES(82, '제목_82','내용내용내용내용:82');
INSERT INTO page_table VALUES(83, '제목_83','내용내용내용내용:83');
INSERT INTO page_table VALUES(84, '제목_84','내용내용내용내용:84');
INSERT INTO page_table VALUES(85, '제목_85','내용내용내용내용:85');
INSERT INTO page_table VALUES(86, '제목_86','내용내용내용내용:86');
INSERT INTO page_table VALUES(87, '제목_87','내용내용내용내용:87');
INSERT INTO page_table VALUES(88, '제목_88','내용내용내용내용:88');
INSERT INTO page_table VALUES(89, '제목_89','내용내용내용내용:89');
INSERT INTO page_table VALUES(90, '제목_90','내용내용내용내용:90');
INSERT INTO page_table VALUES(91, '제목_91','내용내용내용내용:91');
INSERT INTO page_table VALUES(92, '제목_92','내용내용내용내용:92');
INSERT INTO page_table VALUES(93, '제목_93','내용내용내용내용:93');
INSERT INTO page_table VALUES(94, '제목_94','내용내용내용내용:94');
INSERT INTO page_table VALUES(95, '제목_95','내용내용내용내용:95');
INSERT INTO page_table VALUES(96, '제목_96','내용내용내용내용:96');
INSERT INTO page_table VALUES(97, '제목_97','내용내용내용내용:97');
INSERT INTO page_table VALUES(98, '제목_98','내용내용내용내용:98');
INSERT INTO page_table VALUES(99, '제목_99','내용내용내용내용:99');
select * from page_table;
-- 1페이지
select *
from (SELECT *
FROM (
SELECT rownum rnum,idx,title,content
FROM page_table
) pagetable
where rnum <= 20
)
where rnum >= 1;
-- 2페이지
select *
from (SELECT *
FROM (
SELECT rownum rnum,idx,title,content
FROM page_table
) pagetable
where rnum <= 40
)
where rnum >= 21;
.
.
.
-- 5페이지
select *
from (SELECT *
FROM (
SELECT rownum rnum,idx,title,content
FROM page_table
) pagetable
where rnum <= 100
)
where rnum >= 81;