Column name
|
Datatype
|
Size
|
Attributes
|
S_order_no
|
Varchar2
|
6
|
Primary
key/foreign key references order_no of order table
|
Product_no
|
Varchar2
|
6
|
Primary
key/foreign key references product_no of product_master table
|
Qty_order
|
Number
|
8
|
|
Qty_disp
|
Number
|
8
|
|
Product_rate
|
Number
|
10,2
|
Create Table:
create table sales_order_t5
(
sales_order_no varchar2(6),
product_no varchar2(6),
constraint sal_pro_pk_t5 primary key (sales_order_no,product_no),
foreign key (sales_order_no) references order_t5 (order_no),
constraint prod_pk_t5 foreign key (product_no) references product_t5 (prod_no),
qty_order number(8),
qty_disp number(8),
product_rate number(10,2)
);
Insert Query
insert into sales_order_t5 values('o00001','0001','4','4','525');
insert into sales_order_t5 values('o00002','0002','2','1','8400');
insert into sales_order_t5 values('o00003','0003','2','1','5250');
insert into sales_order_t5 values('o00004','0004','10','0','525');
Select Query:
select * from sales_order_t5;
Output:
SALES_ PRODUC QTY_ORDER QTY_DISP PRODUCT_RATE
o00001 0001 4 4 525
o00002 0002 2 1 8400
o00003 0003 2 1 5250
o00004 0004 10 0 525
sales_order_t5 table is not create any problem then you first create product_t5 table, given below.
Create table product_t5
create table product_t5
(
prod_no varchar2(6),
CONSTRAINT prod_no_pk_t5 PRIMARY KEY(prod_no),
description varchar2(20),
unit_price number(4),
qty_on_hand number(4),
category varchar2(10)
);
Insert Query for product_t5:
insert into product_t5 values('0001','xxx','3000','4','A');
insert into product_t5 values('0002','xxx','2000','1','B');
insert into product_t5 values('0003','yyy','1500','3','A');
insert into product_t5 values('0004','zzz','2300','2','C');
insert into product_t5 values('0005','aaa','500','2','C');
