Question: Using SQL developer: Create a query to display all the data from the EMP table. Separate each column by a comma. Name the column THE_OUTPUT.

Using SQL developer:

Create a query to display all the data from the EMP table. Separate each column by a comma. Name the column THE_OUTPUT.

(EMP TABLE)

Using SQL developer: Create a query to display all the data from

WHAT THE OUTPUT SHOULD LOOK LIKE:

THE_OUTPUT

7839,KING,PRESIDENT,,17-NOV-81,5000,,10

7698,BLAKE,MANAGER,7839,01-MAY-81,2850,,30

7782,CLARK,MANAGER,7839,09-JUN-81,2450,,10

7654,MARTIN,SALESMAN,7698,28-SEP-81,1250,1400,30

7499,ALLEN,SALESMAN,7698,20-FEB-81,1600,300,30

7844,TURNER,SALESMAN,7698,08-SEP-81,1500,0,30

7521,WARD,SALESMAN,7698,22-FEB-81,1250,500,30

How could I get an output like that?

is there any way I could do it using SELECT * ?

EMIPNO ENAME08MGRSAL HIREDATECOMM DEPTNO t MGR SAL |) HIREDATE | COMM |): DEPTNO 10 30 10 30 30 30 17839 KING PRESIDENT (null) 5000 17-NOW-81 (null) 7698 BLAKE MANAGER 7839 2850 01-MAY-81 (null) 3 7782 CLARK MANAGER 7839 2450 09-JUN-81 (null) 4 7654 MARTIN SALESMAN 7698 1250 28-SEP-81 1400 5 7499 ALLEN SALESHAN 7698 1600 20-FEB-81 300 6 7844 TURNER SALESMAN 7698 1500 08-SEP-81 7 7521 WARD SALESMAN 7698 1250 22-FEB-81 500

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!