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');