=============
problem 2
=============
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
120011 2.99 14-SEP-08
15-SEP-08
16-SEP-08
21-SEP-08
120021 1.99
120041 1.99
120051 1.99
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
130012 4.99 03-SEP-08
13-SEP-08
21-SEP-08
130022 5.99 04-SEP-07
130031 4.99 29-AUG-08
08-SEP-08
19-SEP-08
130061 1.99
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
210011 .99 08-AUG-08
15-SEP-08
210031 .99 10-SEP-08
16-SEP-08
210041 1.29 10-SEP-08
220013 2.19 22-SEP-08
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
220021 2.19
220032 1.99
220042 1.99
220051 1.99
220061 2.99
220062 2.99 21-SEP-08
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
220063 2.99
220071 2.99
220072 2.99
230012 3.99 05-SEP-08
230033 3.99 10-SEP-08
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
230043 3.99
230052 3.99
230064 5.99
230073 5.99
230074 5.99
320011 1.99
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
320021 1.99
320022 1.99
320031 2.99
320032 2.99 06-SEP-08
330012 3.99
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
330023 4.99 11-SEP-08
330033 5.99
330034 5.99
410041 1.29
420011 2.19 01-SEP-08
420021 2.19
VID_ID VID_RENTAL_PRICE DATE_OUT
------ ---------------- ---------
420031 2.19
420042 2.19
51 rows selected.
=============
problem 3
=============
CLIENT CATEGORY
-------------------------------- ----------
Alpha, Ann Comedy
Beta, Edie
Beta, Bob Action
Carlos, Ann Drama
Delta, David Classic
Epsilon, Emma Classic
Feta, Frank Family
Greta, Gail Action
Harpo, Harry Comedy
9 rows selected.
=============
problem 4
=============
MOVIE_TITLE NUM_RENTALS
---------------------------------------- -----------
Gone with the Wind 7
Indiana Jones and the Temple of Doom 4
Star Wars 3
The Muppet Movie 3
It's a Wonderful Life 1
One Flew Over the Cuckoo's Nest 1
The Empire Strikes Back 1
The Phantom Menace 1
Toy Story 1
Toy Story 2 1
All About Eve 0
MOVIE_TITLE NUM_RENTALS
---------------------------------------- -----------
Babe 0
Clockwork Orange 0
Fatal Attraction 0
Indiana Jones and the Last Crusade 0
Midnight Cowboy 0
Return of the Jedi 0
The Blues Brothers 0
The Matrix 0
The Philadelphia Story 0
20 rows selected.
=============
problem 5
=============
Trigger created.
=============
problem 6
=============
insert into rental(rental_num, client_num, vid_id, date_out, date_due)
*
ERROR at line 1:
ORA-20601: Client credit rating of 0 is too low to permit rentals at this time
ORA-06512: at "ST10.APPROVE_RENTAL", line 10
ORA-04088: error during execution of trigger 'ST10.APPROVE_RENTAL'
=============
problem 7
=============
1 row created.
=============
problem 8
=============
1 row updated.
1 row created.
=============
problem 9
=============
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000001 5555 120011 21-SEP-08 23-SEP-08 22-SEP-08
0000002 2222 130031 19-SEP-08 22-SEP-08
0000003 2222 130012 03-SEP-08 08-SEP-08 04-SEP-08
0000004 3333 130012 21-SEP-08 22-SEP-08
0000005 3333 210011 08-AUG-08 11-AUG-08
0000007 3333 120011 15-SEP-08 18-SEP-08 21-SEP-08
0000008 1111 130022 04-SEP-07 07-SEP-08 14-SEP-08
0000009 6666 130012 13-SEP-08 16-SEP-08 16-SEP-08
0000010 7777 120011 14-SEP-08 17-SEP-08 17-SEP-08
0000011 8888 230012 05-SEP-08 10-SEP-08
0000012 9999 210031 10-SEP-08 13-SEP-08 13-SEP-08
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000013 9999 210041 10-SEP-08 13-SEP-08 13-SEP-08
0000014 9999 230033 10-SEP-08 13-SEP-08 13-SEP-08
0000015 3333 420011 01-SEP-08 04-SEP-08 03-SEP-08
0000016 2222 330023 11-SEP-08 16-SEP-08 15-SEP-08
0000017 5555 220013 22-SEP-08 25-SEP-08
0000018 1111 220062 21-SEP-08 26-SEP-08
0000019 3333 320032 06-SEP-08 09-SEP-08 07-SEP-08
0000020 7777 130031 29-AUG-08 01-SEP-08 02-SEP-08
0000021 6666 210011 15-SEP-08 17-SEP-08
0000022 5555 210031 16-SEP-08 18-SEP-08 17-SEP-08
0000023 4444 120011 16-SEP-08 18-SEP-08 21-SEP-08
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000024 7777 130031 08-SEP-08 10-SEP-08 09-SEP-08
0000025 6666 230052 01-DEC-10 04-DEC-10
0000026 7777 230052 01-DEC-10 04-DEC-10
25 rows selected.
=============
problem 10
=============