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)
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 500Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started