select location_id, container_id, container_status, appt_nbr from container
where container_id like 'B%';
update APPT_STATUS set container_status='D'
where APPT_NBR ='796';
delete from CONTAINER where CONTAINER_id = ‘R0000118000000116273’;
commit;
delete from CONTAINER_history where CONTAINER_id = ‘R0000118000000116273’;
delete from CONTAINER_history
where container_id = ‘00000118000000093215’;
select container_id, attribute, attribute_value from container_attribute
where container_id='B%';
spool /home/retekro/iw.txt
select * from WAVE_DAY_TO_NBR
where wave_nbr=’902’;
spool off
gfab