join table with column name with row field value
946981Feb 13 2013 — edited Feb 13 2013Database version -- 11g
There are 2 table :
table1-- columns are
col1 col2
===========
Name VAL1
Email VAL2
StartDate DATE1
table2 -- columns are
VAL1 VAL2 DATE1
=========================
Test Name Test Email Test Date
The result should look like:
Name Test Name
Email Test Email
StartDate Test Date
How do I achieve this sort of output.
Thanx for help !!