SQL> create table LARGE_SLIP
         (Marina_Num char(4) not null,
         Slip_Num char(4) not null,
         Rental_Fee char(10),
         Boat_name char(50),
         Owner_name char(4),);

---------Table Created--------------

insert into LARGE_SLIP (column1,column2,column3,column4,column5)
values ('1', 'A1', '$3800', 'Anderson II', 'AN75');
values ('1', 'A2', '$3800', 'Our Toy', 'EL25');
values ('1', 'A3', '$3600', 'Escape', 'KE22');
values ('2', '5', '$4200', 'Dolphin 40', 'N027');
values ('2', '6', '$4200', 'Ray 4025', 'TR72');

Update LARGE_SLIP
Set Rental_Fee = ' *150'
where Marina_Num = '1'
where Marina_num = '2' ;

Update LARGE_SLIP
set Rental_Fee = ' -40'
where Rental_Fee = '4200' ;

insert into LARGE_SLIP
values ('1', 'A4', '$3900', 'Bilmore', 'FE82') ;

Delete
From LARGE_SLIP
where Owner_Num = 'TR72" ;

Update LARGE_SLIP
Set Boat_name = 'UNKNOWN'
where Slip_Num = 'A1' ;
Alter LARGE_SLIP
Modify Boat_name = 'UNKNOWN' ;

Alter LARGE_SLIP
add new coloum 'Charter' char(1)

Update LARGE_SLIP
Set = Charter = "Y" ;
where Slip_Num = 'A2' ;

Update LARGE_SLIP
Set  Boat_Name = ' char(60)'
where  Boat_Name = 'char(50)' ;

Alter LARGE_SLIP
Modify Rental_Fee Not Null;

Drop LARGE_SLIP;