SQL Query Or Pl/SQL program output in Different format
Clash Royale CLAN TAG#URR8PPPSQL Query Or Pl/SQL program output in Different format
I have a requirement to get the emp no and salary in different format.
EX:
EMP_NO,FIRST_NAME,LAST_NAME,START_DATE,GENDER,JOB_ID,DEPT_NO,DES,SALARY,CREATION_DATE
INSERT INTO emp VALUES (2,'Jay','Red','21-MAR-01','M',100,10,'',12500','13-APR-17');
INSERT INTO emp VALUES (3,'Neel','Sai','11-JAN-00','M',100,10,'user',12500','13-APR-17');
INSERT INTO emp VALUES (5,'Ravi','','','M',100,10,'',10000','13-APR-17');
INSERT INTO emp VALUES (6,'Maya','V','23-JUL-18','F',101,20,'Tester',23000','23-JUL-18');
INSERT INTO emp VALUES (7,'Rush','Shig','23-JUL-18','M',101,20,'Ast Manager',25000','23-JUL-18');
INSERT INTO emp VALUES (8,'Mark','Philip','20-MAY-17','M',101,20,'Manager',35000','23-JUL-18');
INSERT INTO emp VALUES (9,'Sue','Ng','14-NOV-17','F',101,20,'Ast Manager',25000','23-JUL-18');
INSERT INTO emp VALUES (10,'Srikanth','Vaya','10-SEP-11','M',102,30,'Developer',15000','23-JUL-18');
Such display issues should not be tackled with SQL, but in your app or Website that is displaying the data.
– Thorsten Kettner
13 mins ago
Posted some source data..
– Redro
6 mins ago
But what is the needed result for that data? say you are running your query in SQLPlus, what should the result be? (text please, not images)
– Aleksej
1 min ago
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Please post some sample data, needed result and what you tried so far. Please post data as formatted text, not screenshots
– Aleksej
14 mins ago