Hi,

"I want the row data in a column Format with Table_name  and Column Name."

Suppose i have a Emp table and Dept table.
 
HIS3>  desc emp
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 EMPNO                                                 NOT NULL NUMBER(4)
 ENAME                                                          VARCHAR2(10)
 JOB                                                            VARCHAR2(9)
 MGR                                                            NUMBER(4)
 HIREDATE                                                       DATE
 SAL                                                            NUMBER(7,2)
 COMM                                                           NUMBER(7,2)
 DEPTNO                                                         NUMBER(2)


HIS3>  desc dept
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- --------------
 DEPTNO                                                NOT NULL NUMBER(2)
 DNAME                                                          VARCHAR2(14)
 LOC                                                            VARCHAR2(13)

HIS3>  SELECT * FROM EMP;

    EMPNO ENAME      JOB             MGR HIREDATE        SAL      COMM    DEPTNO
--------- ---------- --------- --------- --------- --------- --------- ---------
     7369 SMITH      CLERK          7902 17-DEC-80       800                  20
     7499 ALLEN      SALESMAN       7698 20-FEB-81      1600       300        30
     7521 WARD       SALESMAN       7698 22-FEB-81      1250       500        30
     7566 JONES      MANAGER        7839 02-APR-81      2975                  20
     7654 MARTIN     SALESMAN       7698 28-SEP-81      1250      1400        30
     7698 BLAKE      MANAGER        7839 01-MAY-81      2850                  30
     7782 CLARK      MANAGER        7839 09-JUN-81      2450                  10
     7788 SCOTT      ANALYST        7566 19-APR-87      3000                  20
     7839 KING       PRESIDENT           17-NOV-81      5000                  10
     7844 TURNER     SALESMAN       7698 08-SEP-81      1500         0        30
     7876 ADAMS      CLERK          7788 23-MAY-87      1100                  20
     7900 JAMES      CLERK          7698 03-DEC-81       950                  30
     7902 FORD       ANALYST        7566 03-DEC-81      3000                  20
     7934 MILLER     CLERK          7782 23-JAN-82      1300

14 rows selected.

HIS3>  select * from dept;

   DEPTNO DNAME          LOC
--------- -------------- -------------
       10 ACCOUNTING     NEW YORK
       20 RESEARCH       DALLAS
       30 SALES          CHICAGO
       40 OPERATIONS     BOSTON

I want a query which gives me something like this type of output -->

SAY  i want details for a particular employee with empno =7369

Table 			Column 			Data
----------------------- ----------------------- --------------
EMP			EMPNO			7369
EMP			ENAME			SMITH		
EMP			JOB			CLERK
EMP			MGR			7902
EMP			HIREDATE		17-DEC-80
EMP			SAL			 800
EMP			DEPTNO			20
DEPT			DNAME			RESEARCH
DEPT			LOC			DALLAS


Hope you got it..

But there is one catch .
i want to display only those columns in which the Data is there.
Now take this example , for employee 'SMITH', there is no commission. So that column should not be displayed.



Thanks in Advance,

Amrish KOthari