SQL> create table sale_order(order_no char(6) primary key, order_date date, client_no char(6),
2 salesman_no char(6), dely_date date, order_status char(15), foreign key(client_no) references
3 client_master(client_no));
Table created.
SQL> insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
2 '&delay_date', '&order_status');
Enter value for order_no: O19001
Enter value for order_date: 12-Jan-13
Enter value for client_no: C00001
Enter value for salesman_no: S00001
old 1: insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
new 1: insert into sale_order values('O19001', '12-Jan-13', 'C00001', 'S00001',
Enter value for delay_date: 20-Jan-13
Enter value for order_status: In process
old 2: '&delay_date', '&order_status')
new 2: '20-Jan-13', 'In process')
1 row created.
SQL> /
Enter value for order_no: O19002
Enter value for order_date: 25-Jan-13
Enter value for client_no: C00002
Enter value for salesman_no: S00002
old 1: insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
new 1: insert into sale_order values('O19002', '25-Jan-13', 'C00002', 'S00002',
Enter value for delay_date: 27-Jan-13
Enter value for order_status: Cancelled
old 2: '&delay_date', '&order_status')
new 2: '27-Jan-13', 'Cancelled')
1 row created.
SQL> /
Enter value for order_no: O46865
Enter value for order_date: 18-Feb-13
Enter value for client_no: C00003
Enter value for salesman_no: S00003
old 1: insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
new 1: insert into sale_order values('O46865', '18-Feb-13', 'C00003', 'S00003',
Enter value for delay_date: 20-Feb-13
Enter value for order_status: Fulfilled
old 2: '&delay_date', '&order_status')
new 2: '20-Feb-13', 'Fulfilled')
1 row created.
SQL> /
Enter value for order_no: O19003
Enter value for order_date: 03-Apr-13
Enter value for client_no: C00001
Enter value for salesman_no: S00001
old 1: insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
new 1: insert into sale_order values('O19003', '03-Apr-13', 'C00001', 'S00001',
Enter value for delay_date: 07-Apr-13
Enter value for order_status: Fulfilled
old 2: '&delay_date', '&order_status')
new 2: '07-Apr-13', 'Fulfilled')
1 row created.
SQL> /
Enter value for order_no: O46866
Enter value for order_date: 20-May-13
Enter value for client_no: C00004
Enter value for salesman_no: S00002
old 1: insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
new 1: insert into sale_order values('O46866', '20-May-13', 'C00004', 'S00002',
Enter value for delay_date: 07-Apr-13
Enter value for order_status: Cancelled
old 2: '&delay_date', '&order_status')
new 2: '07-Apr-13', 'Cancelled')
1 row created.
SQL> /
Enter value for order_no: O19008
Enter value for order_date: 24-May-13
Enter value for client_no: C00005
Enter value for salesman_no: S00004
old 1: insert into sale_order values('&order_no', '&order_date', '&client_no', '&salesman_no',
new 1: insert into sale_order values('O19008', '24-May-13', 'C00005', 'S00004',
Enter value for delay_date: 26-May-13
Enter value for order_status: In process
old 2: '&delay_date', '&order_status')
new 2: '26-May-13', 'In process')
1 row created.
SQL> select * from sale_order;
ORDER_ ORDER_DAT CLIENT SALESM DELY_DATE ORDER_STATUS
------ --------- ------ ------ --------- ---------------
O19001 12-JAN-13 C00001 S00001 20-JAN-13 In process
O19002 25-JAN-13 C00002 S00002 27-JAN-13 Cancelled
O46865 18-FEB-13 C00003 S00003 20-FEB-13 Fulfilled
O19003 03-APR-13 C00001 S00001 07-APR-13 Fulfilled
O46866 20-MAY-13 C00004 S00002 07-APR-13 Cancelled
O19008 24-MAY-13 C00005 S00004 26-MAY-13 In process
6 rows selected.
|
