[Oracle]오라클 테스트 데이터(SELECT용)

 

오라클 데이터 베이스 테스트용 데이터

- 프로그래머스 모든 레코드 조회하기에서 가져와 수정하였습니다.

- 각각 아이디, 생물 종, 보호 시작일, 보호 시작시 상태, 이름, 성별 및 중성화 여부를 나타냅니다.

 

CREATE문

CREATE TABLE ANIMAL (
    ANIMAL_ID VARCHAR2(50) CONSTRAINT ANIMAL_PK PRIMARY KEY,
    ANIMAL_TYPE VARCHAR2(50),
    DATETIME VARCHAR2(50),
    INTAKE_CONDITION VARCHAR2(50),
    NAME VARCHAR2(50),
    SEX_UPON_INTAKE VARCHAR2(50)
);

INSERT문

INSERT INTO ANIMAL VALUES('A349996', 'Cat', '2018-01-22', 'Normal', 'Sugar', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A350276', 'Cat', '2017-08-13', 'Normal', 'Jewel', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A350375', 'Cat', '2017-03-06', 'Normal', 'Meo', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A352555', 'Dog', '2014-08-08', 'Normal', 'Harley', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A352713', 'Cat', '2017-04-13', 'Normal', 'Gia', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A352872', 'Dog', '2015-07-09', 'Aged', 'Peanutbutter', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A353259', 'Dog', '2016-05-08', 'Injured', 'Bj', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A354540', 'Cat', '2014-12-11', 'Normal', 'Tux',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A354597', 'Cat', '2014-05-02', 'Normal', 'Ariel', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A354725', 'Dog', '2015-08-26', 'Normal', 'Kia', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A354753', 'Dog', '2017-04-21', 'Normal', 'Sammy', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A355519', 'Dog', '2015-05-08', 'Normal', 'Faith', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A355688', 'Dog', '2014-01-26', 'Normal', 'Shadow', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A355753', 'Dog', '2015-09-10', 'Normal', 'Elijah', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A357021', 'Dog', '2014-12-03', 'Normal', 'Queens', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A357444', 'Dog', '2016-03-11', 'Normal', 'Puppy', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A357846', 'Dog', '2016-03-17', 'Normal', 'Happy', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A358697', 'Dog', '2015-02-06', 'Normal', 'Fuzzo', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A358879', 'Dog', '2015-09-14', 'Normal', 'Simba', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A361391', 'Dog', '2015-03-30', 'Normal', 'Baby Bear', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A362103', 'Dog', '2014-11-18', 'Normal', 'Stitch', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A362383', 'Dog', '2016-04-21', 'Normal', 'Morado', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A362707', 'Dog', '2016-01-27', 'Sick', 'Girly Girl', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A362967', 'Dog', '2014-06-08', 'Normal', 'Honey', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A363653', 'Dog', '2014-11-17', 'Normal', 'Goofy', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A364429', 'Dog', '2015-09-28', 'Normal', 'Hugo',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A365172', 'Dog', '2014-08-26', 'Normal', 'Diablo', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A365302', 'Dog', '2017-01-08', 'Aged', 'Minnie',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A367012', 'Dog', '2015-09-16', 'Sick', 'Miller',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A367438', 'Dog', '2015-09-10', 'Normal', 'Cookie', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A367747', 'Dog', '2014-10-19', 'Normal', 'Woody', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A368742', 'Dog', '2018-02-03', 'Aged', 'Stormy',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A368930', 'Dog', '2014-06-08', 'Normal', '',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A370439', 'Dog', '2016-06-25', 'Normal', 'Sniket', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A370507', 'Cat', '2014-10-27', 'Normal', 'Emily', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A370852', 'Dog', '2013-11-03', 'Normal', 'Katie', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A371000', 'Cat', '2015-07-29', 'Normal', 'Greg',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A371102', 'Dog', '2015-08-03', 'Normal', 'Ceballo', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A371344', 'Dog', '2015-05-11', 'Normal', 'Sailor', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A371534', 'Dog', '2016-06-07', 'Normal', 'April', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A373219', 'Cat', '2014-07-29', 'Normal', 'Ella',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A373687', 'Dog', '2014-03-20', 'Normal', 'Rosie', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A375393', 'Dog', '2015-06-12', 'Aged',   'Dash',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A376322', 'Dog', '2014-02-18', 'Normal', 'Mama Dog', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A376459', 'Dog', '2017-07-09', 'Normal', 'Dora',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A377750', 'Dog', '2017-10-25', 'Normal', 'Lucy',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A378348', 'Dog', '2014-01-25', 'Normal', 'Frijolito', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A378353', 'Dog', '2014-08-02', 'Aged', 'Lyla', 'Intact Female');
INSERT INTO ANIMAL VALUES('A378818', 'Dog', '2014-07-05', 'Normal', 'Zoe', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A378946', 'Dog', '2017-09-28', 'Normal', 'Mercedes', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A379998', 'Dog', '2013-10-23', 'Normal', 'Disciple', 'Intact Male');
INSERT INTO ANIMAL VALUES('A380009', 'Dog', '2016-02-01', 'Normal', 'Pickle', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A380320', 'Dog', '2014-02-03', 'Normal', 'Scooby', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A380420', 'Dog', '2017-08-04', 'Normal', 'Laika', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A380506', 'Dog', '2016-01-22', 'Normal', 'Ruby',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A381173', 'Dog', '2014-08-06', 'Normal', 'Pepper', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A381217', 'Dog', '2017-07-08', 'Sick', 'Cherokee', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A382192', 'Dog', '2015-03-13', 'Normal', 'Maxwell 2', 'Intact Male');
INSERT INTO ANIMAL VALUES('A382251', 'Dog', '2014-11-08', 'Normal', 'Princess', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A383036', 'Cat', '2014-05-29', 'Normal', 'Oreo',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A383964', 'Dog', '2017-02-05', 'Normal', 'Finney', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A384360', 'Cat', '2014-07-04', 'Injured', 'Jj',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A384568', 'Cat', '2014-12-13', 'Normal', 'Jedi',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A385442', 'Dog', '2014-01-11', 'Normal', 'Clyde', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A386005', 'Dog', '2015-09-25', 'Normal', 'Giovanni', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A386276', 'Cat', '2015-12-19', 'Normal', 'Tiko',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A386688', 'Dog', '2015-08-17', 'Aged', 'Punch', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A387083', 'Dog', '2014-02-01', 'Normal', 'Goldie', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A387965', 'Dog', '2014-06-25', 'Sick', 'Dakota',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A388360', 'Dog', '2015-12-25', 'Sick', 'Spider',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A388691', 'Dog', '2015-11-27', 'Normal', 'Blaze', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A390222', 'Dog', '2013-12-08', 'Normal', 'Holly', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A391512', 'Dog', '2016-04-06', 'Normal', 'Rome',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A391858', 'Dog', '2017-03-16', 'Normal', 'Nellie', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A392027', 'Dog', '2014-01-31', 'Normal', 'Penny', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A392075', 'Dog', '2013-11-20', 'Normal', 'Skips', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A392615', 'Dog', '2015-07-26', 'Normal', 'Chip',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A394547', 'Dog', '2015-01-24', 'Normal', 'Snickerdoodl',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A395451', 'Dog', '2015-12-27', 'Normal', 'Rogan', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A396810', 'Dog', '2016-08-22', 'Injured', 'Raven', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A397882', 'Dog', '2017-07-12', 'Injured', 'Charlie', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A399421', 'Dog', '2015-08-25', 'Normal', 'Lucy',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A399552', 'Dog', '2013-10-14', 'Normal', 'Jack',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A400498', 'Dog', '2016-10-04', 'Normal', 'Reggie', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A400680', 'Dog', '2017-06-17', 'Normal', 'Lucy',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A403564', 'Dog', '2013-11-18', 'Normal', 'Anna',	'Spayed Female');
INSERT INTO ANIMAL VALUES('A405494', 'Dog', '2014-05-16', 'Normal', 'Kaila', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A406756', 'Dog', '2016-05-12', 'Injured', 'Sabrina', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A407156', 'Dog', '2016-10-18', 'Normal', 'Jake',	'Neutered Male');
INSERT INTO ANIMAL VALUES('A408035', 'Dog', '2014-12-25', 'Normal', 'Lizzie', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A409637', 'Dog', '2016-04-02', 'Aged', 'Stanley', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A410330', 'Dog', '2016-09-11', 'Sick', 'Chewy', 'Intact Female');
INSERT INTO ANIMAL VALUES('A410668', 'Cat', '2015-11-19', 'Normal', 'Raven', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A410684', 'Cat', '2014-06-21', 'Normal', 'Mitty', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A412173', 'Dog', '2015-07-28', 'Normal', 'Jimminee', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A412626', 'Dog', '2016-03-13', 'Normal', 'Sam', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A412697', 'Dog', '2016-01-03', 'Normal', 'Jackie', 'Neutered Male');
INSERT INTO ANIMAL VALUES('A413789', 'Dog', '2016-04-19', 'Normal', 'Benji', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A414198', 'Dog', '2015-01-29', 'Normal', 'Shelly', 'Spayed Female');
INSERT INTO ANIMAL VALUES('A414513', 'Dog', '2016-06-07', 'Normal', 'Rocky', 'Neutered Male');