SQL> create table sales_order_details(order_no varchar(6), product_code varchar(6),
2 qty_ordered number(4), product_rate number(6), foreign key(product_code)
3 references product_master(product_code));
Table created.
SQL> insert into sales_order_details values('&order_no', '&product_code',
2 &qty_ordered, &product_rate);
Enter value for order_no: O19001
Enter value for product_code: P00001
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19001', 'P00001',
Enter value for qty_ordered: 4
Enter value for product_rate: 525
old 2: &qty_ordered, &product_rate)
new 2: 4, 525)
1 row created.
SQL> /
Enter value for order_no: O19001
Enter value for product_code: P07965
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19001', 'P07965',
Enter value for qty_ordered: 2
Enter value for product_rate: 8400
old 2: &qty_ordered, &product_rate)
new 2: 2, 8400)
1 row created.
SQL> /
Enter value for order_no: O19001
Enter value for product_code: P07885
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19001', 'P07885',
Enter value for qty_ordered: 2
Enter value for product_rate: 5250
old 2: &qty_ordered, &product_rate)
new 2: 2, 5250)
1 row created.
SQL> /
Enter value for order_no: O19002
Enter value for product_code: P00001
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19002', 'P00001',
Enter value for qty_ordered: 10
Enter value for product_rate: 525
old 2: &qty_ordered, &product_rate)
new 2: 10, 525)
1 row created.
SQL> /
Enter value for order_no: O46865
Enter value for product_code: P07868
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O46865', 'P07868',
Enter value for qty_ordered: 3
Enter value for product_rate: 5250
old 2: &qty_ordered, &product_rate)
new 2: 3, 5250)
1 row created.
SQL> /
Enter value for order_no: O46865
Enter value for product_code: P07885
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O46865', 'P07885',
Enter value for qty_ordered: 3
Enter value for product_rate: 3150
old 2: &qty_ordered, &product_rate)
new 2: 3, 3150)
1 row created.
SQL> /
Enter value for order_no: O46865
Enter value for product_code: P00001
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O46865', 'P00001',
Enter value for qty_ordered: 10
Enter value for product_rate: 525
old 2: &qty_ordered, &product_rate)
new 2: 10, 525)
1 row created.
SQL> /
Enter value for order_no: O46865
Enter value for product_code: P03453
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O46865', 'P03453',
Enter value for qty_ordered: 4
Enter value for product_rate: 1050
old 2: &qty_ordered, &product_rate)
new 2: 4, 1050)
1 row created.
SQL> /
Enter value for order_no: O19003
Enter value for product_code: P03453
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19003', 'P03453',
Enter value for qty_ordered: 2
Enter value for product_rate: 1050
old 2: &qty_ordered, &product_rate)
new 2: 2, 1050)
1 row created.
SQL> /
Enter value for order_no: O19003
Enter value for product_code: P06734
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19003', 'P06734',
Enter value for qty_ordered: 1
Enter value for product_rate: 12000
old 2: &qty_ordered, &product_rate)
new 2: 1, 12000)
1 row created.
SQL> /
Enter value for order_no: O46866
Enter value for product_code: P07965
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O46866', 'P07965',
Enter value for qty_ordered: 1
Enter value for product_rate: 8400
old 2: &qty_ordered, &product_rate)
new 2: 1, 8400)
1 row created.
SQL> /
Enter value for order_no: O46866
Enter value for product_code: P07975
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O46866', 'P07975',
Enter value for qty_ordered: 1
Enter value for product_rate: 1050
old 2: &qty_ordered, &product_rate)
new 2: 1, 1050)
1 row created.
SQL> /
Enter value for order_no: O19008
Enter value for product_code: P00001
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19008', 'P00001',
Enter value for qty_ordered: 10
Enter value for product_rate: 525
old 2: &qty_ordered, &product_rate)
new 2: 10, 525)
1 row created.
SQL> /
Enter value for order_no: O19008
Enter value for product_code: P07975
old 1: insert into sales_order_details values('&order_no', '&product_code',
new 1: insert into sales_order_details values('O19008', 'P07975',
Enter value for qty_ordered: 5
Enter value for product_rate: 1050
old 2: &qty_ordered, &product_rate)
new 2: 5, 1050)
1 row created.
SQL> select * from sales_order_details;
ORDER_ PRODUC QTY_ORDERED PRODUCT_RATE
------ ------ ----------- ------------
O19001 P00001 4 525
O19001 P07965 2 8400
O19001 P07885 2 5250
O19002 P00001 10 525
O46865 P07868 3 5250
O46865 P07885 3 3150
O46865 P00001 10 525
O46865 P03453 4 1050
O19003 P03453 2 1050
O19003 P06734 1 12000
O46866 P07965 1 8400
ORDER_ PRODUC QTY_ORDERED PRODUCT_RATE
------ ------ ----------- ------------
O46866 P07975 1 1050
O19008 P00001 10 525
O19008 P07975 5 1050
14 rows selected.
|
