Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems An Application Oriented Approach Complete Version

Authors: Michael Kifer, Arthur Bernstein, Richard Lewis

2nd Edition

0321268458, 978-0321268457

More Books

Students also viewed these Databases questions

Question

What information remains to be obtained?

Answered: 1 week ago

Question

Question How are IRAs treated for state tax law purposes?

Answered: 1 week ago