Hello Gurus,
Would it possible to use column alias from a table value.
For example I have a table like below.
order_items
| Order_Code | column1 | column2 |
|---|
| APPL | 100 | 50 |
| ORNG | 500 | 200 |
order_codes
| order_code | col1_val | col2_val |
|---|
| APPL | no of cartons recieved | no of cartons shipped |
| ORNG | no of bags recieved | no of bags shipped |
| | |
I would like to display output like below
when I query order_items table
for order_code - APPL
order_code no of cartons recieved no of cartons shipped
APPL 100 50
For order_code - ORNG
order_code no of bags recieved no of bags shipped
ORNG 500 200
Please find create table and insert statement scripts below
create table order_items ( order_code varchar2(100), column1 varchar2(1000), column2 varchar2(1000));
create table order_codes ( order_code varchar2(100), col1_val varchar2(1000), col2_val varchar2(1000));
insert into order_items values ( 'APPL', '100', '50');
insert into order_items values ( 'ORNG', '500', '200');
insert into order_codes values ( 'APPL', 'no of cartons recieved', 'no of cartons shipped');
insert into order_codes values ( 'ORNG', 'no of bags recieved', 'no of bags shipped');