---------
-- lect08-setup.sql
--
-- example table with some initial contents for CS 318 
--    Week 8 Lecture examples
--
-- original by: Ann Burroughs
-- modified by: Sharon Tuttle
-- last modified: 3-13-13
------------

drop table table_from_java;

create table table_from_java
(pk_tbl_java	number,
 date_placed    date,
 desired_color	varchar2(20),
 item_code	int,
 deposit_so_far	number(6, 2),
 primary key    (pk_tbl_java)
);

insert into table_from_java
values
(100, sysdate, 'purple', 5000, 569.32);

insert into table_from_java
values
(101, sysdate, 'magenta', 1000, 425.7);

commit;

-- end of lect08-setup.sql