Animals database created in Oracle AJAX

animals-database

1.
CREATE TABLE animals
 (animal_id NUMBER(6),
  name VARCHAR2(25),
  license_tag_number NUMBER(10), 
  admit_date DATE CONSTRAINT animals_admit_date_nn NOT NULL,
  adoption_id NUMBER(5),
  vaccination_date DATE CONSTRAINT animals_vaccination_date_nn NOT NULL,
  CONSTRAINT animals_animal_id_pk PRIMARY KEY (animal_id),
  CONSTRAINT animals_license_tag_number_uk UNIQUE (license_tag_number));

2.
INSERT 	INTO animals
VALUES (101, 'Spot', 35540, '10-OCT-2004', 205, '12-OCT 2004');

INSERT INTO animals
VALUES (102, 'Sonic', 34885, '4-APR-2004', 302, '6-APR-2004');

3. 
INSERT INTO animals
VALUES 
 (103, 'Archie', 36250, '3-MAR-2004', 403, '5-MAR-2004');

4. 
CREATE TABLE adoptions
  (adoption_id NUMBER(5),
   adoption_date DATE DEFAULT SYSDATE,
   last_name VARCHAR2(20),
   first_name VARCHAR2(20),
   phone VARCHAR2(12) CONSTRAINT adoptions_phone_nn NOT NULL,
   email VARCHAR2(30),
   CONSTRAINT adoptions_adoption_id_pk PRIMARY KEY (adoption_id),
   CONSTRAINT adoptions_email_uk UNIQUE (email));
5. 
UPDATE animals
   SET license_tag_number = '33999'
   WHERE animal_id = 102;

6.
ALTER TABLE animals
ADD (adoption_date DATE DEFAULT SYSDATE);

7.
ALTER TABLE animals
ADD (owner_name VARCHAR2(30));

8. 
INSERT INTO animals
VALUES
 (104, 'Dobby', 36350, '5-MAR-2006', 507, '7-MAR-2006', DEFAULT, 'Shaina Read');

9. 
ALTER TABLE animals
MODIFY (license_tag_number NUMBER(10));

10. 
COMMENT ON TABLE animals
IS 'ADOPT ME';

11.
SELECT comments
FROM user_tab_comments;

12.
CREATE TABLE copy_animals
AS (SELECT * FROM animals);

13.
ALTER TABLE copy_animals
SET UNUSED (owner_name);

14. 
ALTER TABLE copy_animals
DROP UNUSED COLUMNS;

15. 
TRUNCATE TABLE copy_animals;

16.
RENAME copy_animals TO new_animals;

17. 
DROP TABLE new_animals;

18. 
SELECT original_name, operation, droptime
FROM user_recyclebin;

19.
FLASHBACK TABLE new_animals TO BEFORE DROP;