Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
create table
Sush_emp_work
Srinivas
0607-3
neha1
wq1
My_employee
Cursor Explicit
Srinivas
SQLWithOuterAndInnerLoop_UnableToExecute