Oracle Sandbox: Dog Data, Oracle

Oracle Sandbox: Dog Data

--Oracle 11g Express Edition
--please drop objects you've created at the end of the script 
--or check for their existance before creating
--'\\' is a delimiter

Drop table dogs\\

create table dogs (
license NUMBER
, name VARCHAR(20)
, age_yy NUMBER
, breed VARCHAR(30)
, color VARCHAR(20)
)\\

Insert all 
into dogs (license, name, age_yy, breed, color) values (4294, 'Zeke', 3, 'Bassett Hound', 'gray')
into dogs (license, name, age_yy, breed, color) values (2586, 'Remi', 2, 'Saint Bernard', 'brown')
into dogs (license, name, age_yy, breed, color) values (1263, 'Spot', 5, 'Dalmatian', 'white')
into dogs (license, name, age_yy, breed, color) values (8576, 'Casey', 9, 'Spaniel', 'black')
into dogs (license, name, age_yy, breed, color) values (7870, 'Leo', 4, 'Retriever', 'golden')
into dogs (license, name, age_yy, breed, color) values (2547, 'Jack', 8, 'Poodle', 'black')
into dogs (license, name, age_yy, breed, color) values (6539, 'Lady', 5, 'Pug', 'tan')
select 1 from dual\\

select * from dogs\\

drop table adoption_log\\

create table adoption_log (
 license_no NUMBER
, date_adopted VARCHAR(20)
, neighborhood VARCHAR(30)
)\\

Insert all 
into adoption_log (license_no, date_adopted, neighborhood) values (2547, '12-11-2016', 'Ballard')
into adoption_log (license_no, date_adopted, neighborhood) values (8576, '11-13-2016', 'U District')
into adoption_log (license_no, date_adopted, neighborhood) values (4294, '12-1-2016', 'Montlake')
into adoption_log (license_no, date_adopted, neighborhood) values (2586, '11-22-2016', 'Columbia City')
into adoption_log (license_no, date_adopted, neighborhood) values (1263, '11-8-2016', 'Magnolia')
into adoption_log (license_no, date_adopted, neighborhood) values (7870, '12-4-2016', 'Central District')
into adoption_log (license_no, date_adopted, neighborhood) values (6539, '12-2-2016', 'West Seattle')
select 1 from dual\\

select * from adoption_log\\


run \| edit \| history \| help	0