SQL> create table product_master(product_code varchar(6) primary key, description varchar(20),
2 qty_on_hand number(4), sell_price number(6));
Table created.
SQL> insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_price);
Enter value for product_code: P00001
Enter value for description: 1.44 FLOPPIES
Enter value for qty_on_hand: 100
Enter value for sell_price: 525
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P00001', '1.44 FLOPPIES', 100, 525)
1 row created.
SQL> /
Enter value for product_code: P03453
Enter value for description: MONITORS
Enter value for qty_on_hand: 10
Enter value for sell_price: 12000
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P03453', 'MONITORS', 10, 12000)
1 row created.
SQL> /
Enter value for product_code: P06734
Enter value for description: MOUSE
Enter value for qty_on_hand: 20
Enter value for sell_price: 1050
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P06734', 'MOUSE', 20, 1050)
1 row created.
SQL> /
Enter value for product_code: P07865
Enter value for description: 1.22 FLOPPIES
Enter value for qty_on_hand: 100
Enter value for sell_price: 525
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P07865', '1.22 FLOPPIES', 100, 525)
1 row created.
SQL> /
Enter value for product_code: P07868
Enter value for description: KEYBOARDS
Enter value for qty_on_hand: 10
Enter value for sell_price: 3150
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P07868', 'KEYBOARDS', 10, 3150)
1 row created.
SQL> /
Enter value for product_code: P07885
Enter value for description: CD DRIVE
Enter value for qty_on_hand: 10
Enter value for sell_price: 5250
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P07885', 'CD DRIVE', 10, 5250)
1 row created.
SQL> /
Enter value for product_code: P07965
Enter value for description: 540 HDD
Enter value for qty_on_hand: 10
Enter value for sell_price: 8400
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P07965', '540 HDD', 10, 8400)
1 row created.
SQL> /
Enter value for product_code: P07975
Enter value for description: 1.44 DRIVE
Enter value for qty_on_hand: 10
Enter value for sell_price: 1050
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P07975', '1.44 DRIVE', 10, 1050)
1 row created.
SQL> /
Enter value for product_code: P08865
Enter value for description: 1.22 DRIVE
Enter value for qty_on_hand: 2
Enter value for sell_price: 1050
old 1: insert into product_master values('&product_code', '&description', &qty_on_hand, &sell_pric
new 1: insert into product_master values('P08865', '1.22 DRIVE', 2, 1050)
1 row created.
SQL> select * from product_master;
PRODUC DESCRIPTION QTY_ON_HAND SELL_PRICE
------ -------------------- ----------- ----------
P00001 1.44 FLOPPIES 100 525
P03453 MONITORS 10 12000
P06734 MOUSE 20 1050
P07865 1.22 FLOPPIES 100 525
P07868 KEYBOARDS 10 3150
P07885 CD DRIVE 10 5250
P07965 540 HDD 10 8400
P07975 1.44 DRIVE 10 1050
P08865 1.22 DRIVE 2 1050
9 rows selected.
|
