I want to get the table result set's 1st record should have the column name's then it should follow by the corresponding data.
for example considering emp table my result should be :-
| "EMPNO" | "ENAME" | "JOB" | "MGR" | "HIREDATE" | "SAL" | "COMM" | "DEPTNO" |
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
| 7839 | "KING" | "PRESIDENT" | | 17-11-81 | 5000 | | 10 |
| 7698 | "BLAKE" | "MANAGER" | 7839 | 01-05-81 | 2850 | | 30 |
| 7782 | "CLARK" | "MANAGER" | 7839 | 09-06-81 | 2450 | | 10 |
| 7566 | "JONES" | "MANAGER" | 7839 | 02-04-81 | 2975 | | 20 |
| 7788 | "SCOTT" | "ANALYST" | 7566 | 19-04-87 | 3000 | | 20 |
| 7902 | "FORD" | "ANALYST" | 7566 | 03-12-81 | 3000 | | 20 |
| 7369 | "SMITH" | "CLERK" | 7902 | 17-12-80 | 800 | | 20 |
| 7499 | "ALLEN" | "SALESMAN" | 7698 | 20-02-81 | 1600 | 300 | 30 |
| 7521 | "WARD" | "SALESMAN" | 7698 | 22-02-81 | 1250 | 500 | 30 |
| 7654 | "MARTIN" | "SALESMAN" | 7698 | 28-09-81 | 1250 | 1400 | 30 |
| 7844 | "TURNER" | "SALESMAN" | 7698 | 08-09-81 | 1500 | 0 | 30 |
| 7876 | "ADAMS" | "CLERK" | 7788 | 23-05-87 | 1100 | | 20 |
| 7900 | "JAMES" | "CLERK" | 7698 | 03-12-81 | 950 | | 30 |
| 7934 | "MILLER" | "CLERK" | 7782 | 23-01-82 | 1300 | | 10 |
How can i do this using oracle 11g/12c.
Thanks in advance.