[프로그래머스 - ORACLE] 모든 레코드 조회하기

---

CREATE 문

CREATE TABLE ANIMAL_INS       (
ANIMAL_ID			VARCHAR2(100)	NOT NULL,
ANIMAL_TYPE			VARCHAR2(100)	NOT NULL,
DATETIME 			TIMESTAMP 	NOT NULL,
INTAKE_CONDITION		VARCHAR2(100)	NOT NULL,
NAME				VARCHAR2(100)	NULL,
SEX_UPON_INTAKE			VARCHAR2(100)	NOT NULL
);

 

---

• 내 풀이

SELECT * FROM ANIMAL_INS 
ORDER BY ANIMAL_ID ASC;