오라클 데이터 베이스 테스트용 데이터
- 집계함수를 테스트하기 위한 복붙용 데이터를 만들었습니다.
- 테이블은 2022년도의 날짜를 담고 있습니다.
- 컬럼은 아이디, 년도, 월, 일, 날짜입니다.
CREATE문
CREATE TABLE CALENDAR (
ID NUMBER NOT NULL CONSTRAINT CALENDAR_PK PRIMARY KEY,
YEAR NUMBER,
MONTH NUMBER,
DAY NUMBER,
FULLDATE VARCHAR(10)
);INSERT문
INSERT ALL
INTO CALENDAR VALUES(1, 2022, 1, 1, '2022/01/01')
INTO CALENDAR VALUES(2, 2022, 1, 2, '2022/01/02')
INTO CALENDAR VALUES(3, 2022, 1, 3, '2022/01/03')
INTO CALENDAR VALUES(4, 2022, 1, 4, '2022/01/04')
INTO CALENDAR VALUES(5, 2022, 1, 5, '2022/01/05')
INTO CALENDAR VALUES(6, 2022, 1, 6, '2022/01/06')
INTO CALENDAR VALUES(7, 2022, 1, 7, '2022/01/07')
INTO CALENDAR VALUES(8, 2022, 1, 8, '2022/01/08')
INTO CALENDAR VALUES(9, 2022, 1, 9, '2022/01/09')
INTO CALENDAR VALUES(10, 2022, 1, 10, '2022/01/10')
INTO CALENDAR VALUES(11, 2022, 1, 11, '2022/01/11')
INTO CALENDAR VALUES(12, 2022, 1, 12, '2022/01/12')
INTO CALENDAR VALUES(13, 2022, 1, 13, '2022/01/13')
INTO CALENDAR VALUES(14, 2022, 1, 14, '2022/01/14')
INTO CALENDAR VALUES(15, 2022, 1, 15, '2022/01/15')
INTO CALENDAR VALUES(16, 2022, 1, 16, '2022/01/16')
INTO CALENDAR VALUES(17, 2022, 1, 17, '2022/01/17')
INTO CALENDAR VALUES(18, 2022, 1, 18, '2022/01/18')
INTO CALENDAR VALUES(19, 2022, 1, 19, '2022/01/19')
INTO CALENDAR VALUES(20, 2022, 1, 20, '2022/01/20')
INTO CALENDAR VALUES(21, 2022, 1, 21, '2022/01/21')
INTO CALENDAR VALUES(22, 2022, 1, 22, '2022/01/22')
INTO CALENDAR VALUES(23, 2022, 1, 23, '2022/01/23')
INTO CALENDAR VALUES(24, 2022, 1, 24, '2022/01/24')
INTO CALENDAR VALUES(25, 2022, 1, 25, '2022/01/25')
INTO CALENDAR VALUES(26, 2022, 1, 26, '2022/01/26')
INTO CALENDAR VALUES(27, 2022, 1, 27, '2022/01/27')
INTO CALENDAR VALUES(28, 2022, 1, 28, '2022/01/28')
INTO CALENDAR VALUES(29, 2022, 1, 29, '2022/01/29')
INTO CALENDAR VALUES(30, 2022, 1, 30, '2022/01/30')
INTO CALENDAR VALUES(31, 2022, 1, 31, '2022/01/31')
INTO CALENDAR VALUES(32, 2022, 2, 1, '2022/02/01')
INTO CALENDAR VALUES(33, 2022, 2, 2, '2022/02/02')
INTO CALENDAR VALUES(34, 2022, 2, 3, '2022/02/03')
INTO CALENDAR VALUES(35, 2022, 2, 4, '2022/02/04')
INTO CALENDAR VALUES(36, 2022, 2, 5, '2022/02/05')
INTO CALENDAR VALUES(37, 2022, 2, 6, '2022/02/06')
INTO CALENDAR VALUES(38, 2022, 2, 7, '2022/02/07')
INTO CALENDAR VALUES(39, 2022, 2, 8, '2022/02/08')
INTO CALENDAR VALUES(40, 2022, 2, 9, '2022/02/09')
INTO CALENDAR VALUES(41, 2022, 2, 10, '2022/02/10')
INTO CALENDAR VALUES(42, 2022, 2, 11, '2022/02/11')
INTO CALENDAR VALUES(43, 2022, 2, 12, '2022/02/12')
INTO CALENDAR VALUES(44, 2022, 2, 13, '2022/02/13')
INTO CALENDAR VALUES(45, 2022, 2, 14, '2022/02/14')
INTO CALENDAR VALUES(46, 2022, 2, 15, '2022/02/15')
INTO CALENDAR VALUES(47, 2022, 2, 16, '2022/02/16')
INTO CALENDAR VALUES(48, 2022, 2, 17, '2022/02/17')
INTO CALENDAR VALUES(49, 2022, 2, 18, '2022/02/18')
INTO CALENDAR VALUES(50, 2022, 2, 19, '2022/02/19')
INTO CALENDAR VALUES(51, 2022, 2, 20, '2022/02/20')
INTO CALENDAR VALUES(52, 2022, 2, 21, '2022/02/21')
INTO CALENDAR VALUES(53, 2022, 2, 22, '2022/02/22')
INTO CALENDAR VALUES(54, 2022, 2, 23, '2022/02/23')
INTO CALENDAR VALUES(55, 2022, 2, 24, '2022/02/24')
INTO CALENDAR VALUES(56, 2022, 2, 25, '2022/02/25')
INTO CALENDAR VALUES(57, 2022, 2, 26, '2022/02/26')
INTO CALENDAR VALUES(58, 2022, 2, 27, '2022/02/27')
INTO CALENDAR VALUES(59, 2022, 2, 28, '2022/02/28')
INTO CALENDAR VALUES(60, 2022, 3, 1, '2022/03/01')
INTO CALENDAR VALUES(61, 2022, 3, 2, '2022/03/02')
INTO CALENDAR VALUES(62, 2022, 3, 3, '2022/03/03')
INTO CALENDAR VALUES(63, 2022, 3, 4, '2022/03/04')
INTO CALENDAR VALUES(64, 2022, 3, 5, '2022/03/05')
INTO CALENDAR VALUES(65, 2022, 3, 6, '2022/03/06')
INTO CALENDAR VALUES(66, 2022, 3, 7, '2022/03/07')
INTO CALENDAR VALUES(67, 2022, 3, 8, '2022/03/08')
INTO CALENDAR VALUES(68, 2022, 3, 9, '2022/03/09')
INTO CALENDAR VALUES(69, 2022, 3, 10, '2022/03/10')
INTO CALENDAR VALUES(70, 2022, 3, 11, '2022/03/11')
INTO CALENDAR VALUES(71, 2022, 3, 12, '2022/03/12')
INTO CALENDAR VALUES(72, 2022, 3, 13, '2022/03/13')
INTO CALENDAR VALUES(73, 2022, 3, 14, '2022/03/14')
INTO CALENDAR VALUES(74, 2022, 3, 15, '2022/03/15')
INTO CALENDAR VALUES(75, 2022, 3, 16, '2022/03/16')
INTO CALENDAR VALUES(76, 2022, 3, 17, '2022/03/17')
INTO CALENDAR VALUES(77, 2022, 3, 18, '2022/03/18')
INTO CALENDAR VALUES(78, 2022, 3, 19, '2022/03/19')
INTO CALENDAR VALUES(79, 2022, 3, 20, '2022/03/20')
INTO CALENDAR VALUES(80, 2022, 3, 21, '2022/03/21')
INTO CALENDAR VALUES(81, 2022, 3, 22, '2022/03/22')
INTO CALENDAR VALUES(82, 2022, 3, 23, '2022/03/23')
INTO CALENDAR VALUES(83, 2022, 3, 24, '2022/03/24')
INTO CALENDAR VALUES(84, 2022, 3, 25, '2022/03/25')
INTO CALENDAR VALUES(85, 2022, 3, 26, '2022/03/26')
INTO CALENDAR VALUES(86, 2022, 3, 27, '2022/03/27')
INTO CALENDAR VALUES(87, 2022, 3, 28, '2022/03/28')
INTO CALENDAR VALUES(88, 2022, 3, 29, '2022/03/29')
INTO CALENDAR VALUES(89, 2022, 3, 30, '2022/03/30')
INTO CALENDAR VALUES(90, 2022, 3, 31, '2022/03/31')
INTO CALENDAR VALUES(91, 2022, 4, 1, '2022/04/01')
INTO CALENDAR VALUES(92, 2022, 4, 2, '2022/04/02')
INTO CALENDAR VALUES(93, 2022, 4, 3, '2022/04/03')
INTO CALENDAR VALUES(94, 2022, 4, 4, '2022/04/04')
INTO CALENDAR VALUES(95, 2022, 4, 5, '2022/04/05')
INTO CALENDAR VALUES(96, 2022, 4, 6, '2022/04/06')
INTO CALENDAR VALUES(97, 2022, 4, 7, '2022/04/07')
INTO CALENDAR VALUES(98, 2022, 4, 8, '2022/04/08')
INTO CALENDAR VALUES(99, 2022, 4, 9, '2022/04/09')
INTO CALENDAR VALUES(100, 2022, 4, 10, '2022/04/10')
INTO CALENDAR VALUES(101, 2022, 4, 11, '2022/04/11')
INTO CALENDAR VALUES(102, 2022, 4, 12, '2022/04/12')
INTO CALENDAR VALUES(103, 2022, 4, 13, '2022/04/13')
INTO CALENDAR VALUES(104, 2022, 4, 14, '2022/04/14')
INTO CALENDAR VALUES(105, 2022, 4, 15, '2022/04/15')
INTO CALENDAR VALUES(106, 2022, 4, 16, '2022/04/16')
INTO CALENDAR VALUES(107, 2022, 4, 17, '2022/04/17')
INTO CALENDAR VALUES(108, 2022, 4, 18, '2022/04/18')
INTO CALENDAR VALUES(109, 2022, 4, 19, '2022/04/19')
INTO CALENDAR VALUES(110, 2022, 4, 20, '2022/04/20')
INTO CALENDAR VALUES(111, 2022, 4, 21, '2022/04/21')
INTO CALENDAR VALUES(112, 2022, 4, 22, '2022/04/22')
INTO CALENDAR VALUES(113, 2022, 4, 23, '2022/04/23')
INTO CALENDAR VALUES(114, 2022, 4, 24, '2022/04/24')
INTO CALENDAR VALUES(115, 2022, 4, 25, '2022/04/25')
INTO CALENDAR VALUES(116, 2022, 4, 26, '2022/04/26')
INTO CALENDAR VALUES(117, 2022, 4, 27, '2022/04/27')
INTO CALENDAR VALUES(118, 2022, 4, 28, '2022/04/28')
INTO CALENDAR VALUES(119, 2022, 4, 29, '2022/04/29')
INTO CALENDAR VALUES(120, 2022, 4, 30, '2022/04/30')
INTO CALENDAR VALUES(121, 2022, 5, 1, '2022/05/01')
INTO CALENDAR VALUES(122, 2022, 5, 2, '2022/05/02')
INTO CALENDAR VALUES(123, 2022, 5, 3, '2022/05/03')
INTO CALENDAR VALUES(124, 2022, 5, 4, '2022/05/04')
INTO CALENDAR VALUES(125, 2022, 5, 5, '2022/05/05')
INTO CALENDAR VALUES(126, 2022, 5, 6, '2022/05/06')
INTO CALENDAR VALUES(127, 2022, 5, 7, '2022/05/07')
INTO CALENDAR VALUES(128, 2022, 5, 8, '2022/05/08')
INTO CALENDAR VALUES(129, 2022, 5, 9, '2022/05/09')
INTO CALENDAR VALUES(130, 2022, 5, 10, '2022/05/10')
INTO CALENDAR VALUES(131, 2022, 5, 11, '2022/05/11')
INTO CALENDAR VALUES(132, 2022, 5, 12, '2022/05/12')
INTO CALENDAR VALUES(133, 2022, 5, 13, '2022/05/13')
INTO CALENDAR VALUES(134, 2022, 5, 14, '2022/05/14')
INTO CALENDAR VALUES(135, 2022, 5, 15, '2022/05/15')
INTO CALENDAR VALUES(136, 2022, 5, 16, '2022/05/16')
INTO CALENDAR VALUES(137, 2022, 5, 17, '2022/05/17')
INTO CALENDAR VALUES(138, 2022, 5, 18, '2022/05/18')
INTO CALENDAR VALUES(139, 2022, 5, 19, '2022/05/19')
INTO CALENDAR VALUES(140, 2022, 5, 20, '2022/05/20')
INTO CALENDAR VALUES(141, 2022, 5, 21, '2022/05/21')
INTO CALENDAR VALUES(142, 2022, 5, 22, '2022/05/22')
INTO CALENDAR VALUES(143, 2022, 5, 23, '2022/05/23')
INTO CALENDAR VALUES(144, 2022, 5, 24, '2022/05/24')
INTO CALENDAR VALUES(145, 2022, 5, 25, '2022/05/25')
INTO CALENDAR VALUES(146, 2022, 5, 26, '2022/05/26')
INTO CALENDAR VALUES(147, 2022, 5, 27, '2022/05/27')
INTO CALENDAR VALUES(148, 2022, 5, 28, '2022/05/28')
INTO CALENDAR VALUES(149, 2022, 5, 29, '2022/05/29')
INTO CALENDAR VALUES(150, 2022, 5, 30, '2022/05/30')
INTO CALENDAR VALUES(151, 2022, 5, 31, '2022/05/31')
INTO CALENDAR VALUES(152, 2022, 6, 1, '2022/06/01')
INTO CALENDAR VALUES(153, 2022, 6, 2, '2022/06/02')
INTO CALENDAR VALUES(154, 2022, 6, 3, '2022/06/03')
INTO CALENDAR VALUES(155, 2022, 6, 4, '2022/06/04')
INTO CALENDAR VALUES(156, 2022, 6, 5, '2022/06/05')
INTO CALENDAR VALUES(157, 2022, 6, 6, '2022/06/06')
INTO CALENDAR VALUES(158, 2022, 6, 7, '2022/06/07')
INTO CALENDAR VALUES(159, 2022, 6, 8, '2022/06/08')
INTO CALENDAR VALUES(160, 2022, 6, 9, '2022/06/09')
INTO CALENDAR VALUES(161, 2022, 6, 10, '2022/06/10')
INTO CALENDAR VALUES(162, 2022, 6, 11, '2022/06/11')
INTO CALENDAR VALUES(163, 2022, 6, 12, '2022/06/12')
INTO CALENDAR VALUES(164, 2022, 6, 13, '2022/06/13')
INTO CALENDAR VALUES(165, 2022, 6, 14, '2022/06/14')
INTO CALENDAR VALUES(166, 2022, 6, 15, '2022/06/15')
INTO CALENDAR VALUES(167, 2022, 6, 16, '2022/06/16')
INTO CALENDAR VALUES(168, 2022, 6, 17, '2022/06/17')
INTO CALENDAR VALUES(169, 2022, 6, 18, '2022/06/18')
INTO CALENDAR VALUES(170, 2022, 6, 19, '2022/06/19')
INTO CALENDAR VALUES(171, 2022, 6, 20, '2022/06/20')
INTO CALENDAR VALUES(172, 2022, 6, 21, '2022/06/21')
INTO CALENDAR VALUES(173, 2022, 6, 22, '2022/06/22')
INTO CALENDAR VALUES(174, 2022, 6, 23, '2022/06/23')
INTO CALENDAR VALUES(175, 2022, 6, 24, '2022/06/24')
INTO CALENDAR VALUES(176, 2022, 6, 25, '2022/06/25')
INTO CALENDAR VALUES(177, 2022, 6, 26, '2022/06/26')
INTO CALENDAR VALUES(178, 2022, 6, 27, '2022/06/27')
INTO CALENDAR VALUES(179, 2022, 6, 28, '2022/06/28')
INTO CALENDAR VALUES(180, 2022, 6, 29, '2022/06/29')
INTO CALENDAR VALUES(181, 2022, 6, 30, '2022/06/30')
INTO CALENDAR VALUES(182, 2022, 7, 1, '2022/07/01')
INTO CALENDAR VALUES(183, 2022, 7, 2, '2022/07/02')
INTO CALENDAR VALUES(184, 2022, 7, 3, '2022/07/03')
INTO CALENDAR VALUES(185, 2022, 7, 4, '2022/07/04')
INTO CALENDAR VALUES(186, 2022, 7, 5, '2022/07/05')
INTO CALENDAR VALUES(187, 2022, 7, 6, '2022/07/06')
INTO CALENDAR VALUES(188, 2022, 7, 7, '2022/07/07')
INTO CALENDAR VALUES(189, 2022, 7, 8, '2022/07/08')
INTO CALENDAR VALUES(190, 2022, 7, 9, '2022/07/09')
INTO CALENDAR VALUES(191, 2022, 7, 10, '2022/07/10')
INTO CALENDAR VALUES(192, 2022, 7, 11, '2022/07/11')
INTO CALENDAR VALUES(193, 2022, 7, 12, '2022/07/12')
INTO CALENDAR VALUES(194, 2022, 7, 13, '2022/07/13')
INTO CALENDAR VALUES(195, 2022, 7, 14, '2022/07/14')
INTO CALENDAR VALUES(196, 2022, 7, 15, '2022/07/15')
INTO CALENDAR VALUES(197, 2022, 7, 16, '2022/07/16')
INTO CALENDAR VALUES(198, 2022, 7, 17, '2022/07/17')
INTO CALENDAR VALUES(199, 2022, 7, 18, '2022/07/18')
INTO CALENDAR VALUES(200, 2022, 7, 19, '2022/07/19')
INTO CALENDAR VALUES(201, 2022, 7, 20, '2022/07/20')
INTO CALENDAR VALUES(202, 2022, 7, 21, '2022/07/21')
INTO CALENDAR VALUES(203, 2022, 7, 22, '2022/07/22')
INTO CALENDAR VALUES(204, 2022, 7, 23, '2022/07/23')
INTO CALENDAR VALUES(205, 2022, 7, 24, '2022/07/24')
INTO CALENDAR VALUES(206, 2022, 7, 25, '2022/07/25')
INTO CALENDAR VALUES(207, 2022, 7, 26, '2022/07/26')
INTO CALENDAR VALUES(208, 2022, 7, 27, '2022/07/27')
INTO CALENDAR VALUES(209, 2022, 7, 28, '2022/07/28')
INTO CALENDAR VALUES(210, 2022, 7, 29, '2022/07/29')
INTO CALENDAR VALUES(211, 2022, 7, 30, '2022/07/30')
INTO CALENDAR VALUES(212, 2022, 7, 31, '2022/07/31')
INTO CALENDAR VALUES(213, 2022, 8, 1, '2022/08/01')
INTO CALENDAR VALUES(214, 2022, 8, 2, '2022/08/02')
INTO CALENDAR VALUES(215, 2022, 8, 3, '2022/08/03')
INTO CALENDAR VALUES(216, 2022, 8, 4, '2022/08/04')
INTO CALENDAR VALUES(217, 2022, 8, 5, '2022/08/05')
INTO CALENDAR VALUES(218, 2022, 8, 6, '2022/08/06')
INTO CALENDAR VALUES(219, 2022, 8, 7, '2022/08/07')
INTO CALENDAR VALUES(220, 2022, 8, 8, '2022/08/08')
INTO CALENDAR VALUES(221, 2022, 8, 9, '2022/08/09')
INTO CALENDAR VALUES(222, 2022, 8, 10, '2022/08/10')
INTO CALENDAR VALUES(223, 2022, 8, 11, '2022/08/11')
INTO CALENDAR VALUES(224, 2022, 8, 12, '2022/08/12')
INTO CALENDAR VALUES(225, 2022, 8, 13, '2022/08/13')
INTO CALENDAR VALUES(226, 2022, 8, 14, '2022/08/14')
INTO CALENDAR VALUES(227, 2022, 8, 15, '2022/08/15')
INTO CALENDAR VALUES(228, 2022, 8, 16, '2022/08/16')
INTO CALENDAR VALUES(229, 2022, 8, 17, '2022/08/17')
INTO CALENDAR VALUES(230, 2022, 8, 18, '2022/08/18')
INTO CALENDAR VALUES(231, 2022, 8, 19, '2022/08/19')
INTO CALENDAR VALUES(232, 2022, 8, 20, '2022/08/20')
INTO CALENDAR VALUES(233, 2022, 8, 21, '2022/08/21')
INTO CALENDAR VALUES(234, 2022, 8, 22, '2022/08/22')
INTO CALENDAR VALUES(235, 2022, 8, 23, '2022/08/23')
INTO CALENDAR VALUES(236, 2022, 8, 24, '2022/08/24')
INTO CALENDAR VALUES(237, 2022, 8, 25, '2022/08/25')
INTO CALENDAR VALUES(238, 2022, 8, 26, '2022/08/26')
INTO CALENDAR VALUES(239, 2022, 8, 27, '2022/08/27')
INTO CALENDAR VALUES(240, 2022, 8, 28, '2022/08/28')
INTO CALENDAR VALUES(241, 2022, 8, 29, '2022/08/29')
INTO CALENDAR VALUES(242, 2022, 8, 30, '2022/08/30')
INTO CALENDAR VALUES(243, 2022, 8, 31, '2022/08/31')
INTO CALENDAR VALUES(244, 2022, 9, 1, '2022/09/01')
INTO CALENDAR VALUES(245, 2022, 9, 2, '2022/09/02')
INTO CALENDAR VALUES(246, 2022, 9, 3, '2022/09/03')
INTO CALENDAR VALUES(247, 2022, 9, 4, '2022/09/04')
INTO CALENDAR VALUES(248, 2022, 9, 5, '2022/09/05')
INTO CALENDAR VALUES(249, 2022, 9, 6, '2022/09/06')
INTO CALENDAR VALUES(250, 2022, 9, 7, '2022/09/07')
INTO CALENDAR VALUES(251, 2022, 9, 8, '2022/09/08')
INTO CALENDAR VALUES(252, 2022, 9, 9, '2022/09/09')
INTO CALENDAR VALUES(253, 2022, 9, 10, '2022/09/10')
INTO CALENDAR VALUES(254, 2022, 9, 11, '2022/09/11')
INTO CALENDAR VALUES(255, 2022, 9, 12, '2022/09/12')
INTO CALENDAR VALUES(256, 2022, 9, 13, '2022/09/13')
INTO CALENDAR VALUES(257, 2022, 9, 14, '2022/09/14')
INTO CALENDAR VALUES(258, 2022, 9, 15, '2022/09/15')
INTO CALENDAR VALUES(259, 2022, 9, 16, '2022/09/16')
INTO CALENDAR VALUES(260, 2022, 9, 17, '2022/09/17')
INTO CALENDAR VALUES(261, 2022, 9, 18, '2022/09/18')
INTO CALENDAR VALUES(262, 2022, 9, 19, '2022/09/19')
INTO CALENDAR VALUES(263, 2022, 9, 20, '2022/09/20')
INTO CALENDAR VALUES(264, 2022, 9, 21, '2022/09/21')
INTO CALENDAR VALUES(265, 2022, 9, 22, '2022/09/22')
INTO CALENDAR VALUES(266, 2022, 9, 23, '2022/09/23')
INTO CALENDAR VALUES(267, 2022, 9, 24, '2022/09/24')
INTO CALENDAR VALUES(268, 2022, 9, 25, '2022/09/25')
INTO CALENDAR VALUES(269, 2022, 9, 26, '2022/09/26')
INTO CALENDAR VALUES(270, 2022, 9, 27, '2022/09/27')
INTO CALENDAR VALUES(271, 2022, 9, 28, '2022/09/28')
INTO CALENDAR VALUES(272, 2022, 9, 29, '2022/09/29')
INTO CALENDAR VALUES(273, 2022, 9, 30, '2022/09/30')
INTO CALENDAR VALUES(274, 2022, 10, 1, '2022/10/01')
INTO CALENDAR VALUES(275, 2022, 10, 2, '2022/10/02')
INTO CALENDAR VALUES(276, 2022, 10, 3, '2022/10/03')
INTO CALENDAR VALUES(277, 2022, 10, 4, '2022/10/04')
INTO CALENDAR VALUES(278, 2022, 10, 5, '2022/10/05')
INTO CALENDAR VALUES(279, 2022, 10, 6, '2022/10/06')
INTO CALENDAR VALUES(280, 2022, 10, 7, '2022/10/07')
INTO CALENDAR VALUES(281, 2022, 10, 8, '2022/10/08')
INTO CALENDAR VALUES(282, 2022, 10, 9, '2022/10/09')
INTO CALENDAR VALUES(283, 2022, 10, 10, '2022/10/10')
INTO CALENDAR VALUES(284, 2022, 10, 11, '2022/10/11')
INTO CALENDAR VALUES(285, 2022, 10, 12, '2022/10/12')
INTO CALENDAR VALUES(286, 2022, 10, 13, '2022/10/13')
INTO CALENDAR VALUES(287, 2022, 10, 14, '2022/10/14')
INTO CALENDAR VALUES(288, 2022, 10, 15, '2022/10/15')
INTO CALENDAR VALUES(289, 2022, 10, 16, '2022/10/16')
INTO CALENDAR VALUES(290, 2022, 10, 17, '2022/10/17')
INTO CALENDAR VALUES(291, 2022, 10, 18, '2022/10/18')
INTO CALENDAR VALUES(292, 2022, 10, 19, '2022/10/19')
INTO CALENDAR VALUES(293, 2022, 10, 20, '2022/10/20')
INTO CALENDAR VALUES(294, 2022, 10, 21, '2022/10/21')
INTO CALENDAR VALUES(295, 2022, 10, 22, '2022/10/22')
INTO CALENDAR VALUES(296, 2022, 10, 23, '2022/10/23')
INTO CALENDAR VALUES(297, 2022, 10, 24, '2022/10/24')
INTO CALENDAR VALUES(298, 2022, 10, 25, '2022/10/25')
INTO CALENDAR VALUES(299, 2022, 10, 26, '2022/10/26')
INTO CALENDAR VALUES(300, 2022, 10, 27, '2022/10/27')
INTO CALENDAR VALUES(301, 2022, 10, 28, '2022/10/28')
INTO CALENDAR VALUES(302, 2022, 10, 29, '2022/10/29')
INTO CALENDAR VALUES(303, 2022, 10, 30, '2022/10/30')
INTO CALENDAR VALUES(304, 2022, 10, 31, '2022/10/31')
INTO CALENDAR VALUES(305, 2022, 11, 1, '2022/11/01')
INTO CALENDAR VALUES(306, 2022, 11, 2, '2022/11/02')
INTO CALENDAR VALUES(307, 2022, 11, 3, '2022/11/03')
INTO CALENDAR VALUES(308, 2022, 11, 4, '2022/11/04')
INTO CALENDAR VALUES(309, 2022, 11, 5, '2022/11/05')
INTO CALENDAR VALUES(310, 2022, 11, 6, '2022/11/06')
INTO CALENDAR VALUES(311, 2022, 11, 7, '2022/11/07')
INTO CALENDAR VALUES(312, 2022, 11, 8, '2022/11/08')
INTO CALENDAR VALUES(313, 2022, 11, 9, '2022/11/09')
INTO CALENDAR VALUES(314, 2022, 11, 10, '2022/11/10')
INTO CALENDAR VALUES(315, 2022, 11, 11, '2022/11/11')
INTO CALENDAR VALUES(316, 2022, 11, 12, '2022/11/12')
INTO CALENDAR VALUES(317, 2022, 11, 13, '2022/11/13')
INTO CALENDAR VALUES(318, 2022, 11, 14, '2022/11/14')
INTO CALENDAR VALUES(319, 2022, 11, 15, '2022/11/15')
INTO CALENDAR VALUES(320, 2022, 11, 16, '2022/11/16')
INTO CALENDAR VALUES(321, 2022, 11, 17, '2022/11/17')
INTO CALENDAR VALUES(322, 2022, 11, 18, '2022/11/18')
INTO CALENDAR VALUES(323, 2022, 11, 19, '2022/11/19')
INTO CALENDAR VALUES(324, 2022, 11, 20, '2022/11/20')
INTO CALENDAR VALUES(325, 2022, 11, 21, '2022/11/21')
INTO CALENDAR VALUES(326, 2022, 11, 22, '2022/11/22')
INTO CALENDAR VALUES(327, 2022, 11, 23, '2022/11/23')
INTO CALENDAR VALUES(328, 2022, 11, 24, '2022/11/24')
INTO CALENDAR VALUES(329, 2022, 11, 25, '2022/11/25')
INTO CALENDAR VALUES(330, 2022, 11, 26, '2022/11/26')
INTO CALENDAR VALUES(331, 2022, 11, 27, '2022/11/27')
INTO CALENDAR VALUES(332, 2022, 11, 28, '2022/11/28')
INTO CALENDAR VALUES(333, 2022, 11, 29, '2022/11/29')
INTO CALENDAR VALUES(334, 2022, 11, 30, '2022/11/30')
INTO CALENDAR VALUES(335, 2022, 12, 1, '2022/12/01')
INTO CALENDAR VALUES(336, 2022, 12, 2, '2022/12/02')
INTO CALENDAR VALUES(337, 2022, 12, 3, '2022/12/03')
INTO CALENDAR VALUES(338, 2022, 12, 4, '2022/12/04')
INTO CALENDAR VALUES(339, 2022, 12, 5, '2022/12/05')
INTO CALENDAR VALUES(340, 2022, 12, 6, '2022/12/06')
INTO CALENDAR VALUES(341, 2022, 12, 7, '2022/12/07')
INTO CALENDAR VALUES(342, 2022, 12, 8, '2022/12/08')
INTO CALENDAR VALUES(343, 2022, 12, 9, '2022/12/09')
INTO CALENDAR VALUES(344, 2022, 12, 10, '2022/12/10')
INTO CALENDAR VALUES(345, 2022, 12, 11, '2022/12/11')
INTO CALENDAR VALUES(346, 2022, 12, 12, '2022/12/12')
INTO CALENDAR VALUES(347, 2022, 12, 13, '2022/12/13')
INTO CALENDAR VALUES(348, 2022, 12, 14, '2022/12/14')
INTO CALENDAR VALUES(349, 2022, 12, 15, '2022/12/15')
INTO CALENDAR VALUES(350, 2022, 12, 16, '2022/12/16')
INTO CALENDAR VALUES(351, 2022, 12, 17, '2022/12/17')
INTO CALENDAR VALUES(352, 2022, 12, 18, '2022/12/18')
INTO CALENDAR VALUES(353, 2022, 12, 19, '2022/12/19')
INTO CALENDAR VALUES(354, 2022, 12, 20, '2022/12/20')
INTO CALENDAR VALUES(355, 2022, 12, 21, '2022/12/21')
INTO CALENDAR VALUES(356, 2022, 12, 22, '2022/12/22')
INTO CALENDAR VALUES(357, 2022, 12, 23, '2022/12/23')
INTO CALENDAR VALUES(358, 2022, 12, 24, '2022/12/24')
INTO CALENDAR VALUES(359, 2022, 12, 25, '2022/12/25')
INTO CALENDAR VALUES(360, 2022, 12, 26, '2022/12/26')
INTO CALENDAR VALUES(361, 2022, 12, 27, '2022/12/27')
INTO CALENDAR VALUES(362, 2022, 12, 28, '2022/12/28')
INTO CALENDAR VALUES(363, 2022, 12, 29, '2022/12/29')
INTO CALENDAR VALUES(364, 2022, 12, 30, '2022/12/30')
INTO CALENDAR VALUES(365, 2022, 12, 31, '2022/12/31')
SELECT * FROM DUAL;
'DATABASE > ORACLE 기본' 카테고리의 다른 글
| [Oracle] 오라클 최댓값, 최솟값 조회 MAX()와 MIN() 함수 (0) | 2022.02.21 |
|---|---|
| [Oracle] 오라클 갯수 조회 COUNT() 함수 (0) | 2022.02.12 |
| [Oracle]오라클 순서 정렬 ORDER BY절 (0) | 2022.02.07 |
| [Oracle]오라클 LIKE 특정문자 검색 사용법 (0) | 2022.02.03 |
| [Oracle]오라클 IN과 NOT IN (0) | 2022.01.23 |