finance_teacher
asked on
ORACLE -- SQL results in "one" CELL ?
How can I change the below SQL so it displays as ONE CELL of results, with commas between values like "CHE, HAZ, PAI" instead of three separate cells ?
select substr(test,2,555) Types
from jobs
where min_salary=1 and substr(test,1,1)='^'
-------------------------- ---------- ---------- ----------
CREATE TABLE "JOBS"
("JOB_ID" VARCHAR2(10),
"JOB_TITLE" VARCHAR2(35),
"MIN_SALARY" NUMBER(6,0),
"MAX_SALARY" NUMBER(6,0),
"TEST" VARCHAR2(5)
) ;
-------------------------- ---------- ---------- -----
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA RY,MAX_SAL ARY,TEST) values ('AD_PRES','President, "ceo"',1,40000,'^CHE');
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA RY,MAX_SAL ARY,TEST) values ('AD_VP','Administration Vice President',1,30000,'^HAZ') ;
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA RY,MAX_SAL ARY,TEST) values ('AD_ASST','Administration Assistant',1,6000,'^PAI');
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA RY,MAX_SAL ARY,TEST) values ('FI_MGR','Finance Manager',1,16000,null);
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA RY,MAX_SAL ARY,TEST) values ('FI_ACCOUNT','Accountant' ,1,9000,nu ll);
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA RY,MAX_SAL ARY,TEST) values ('AC_MGR','Accounting Manager',1,16000,null);
select substr(test,2,555) Types
from jobs
where min_salary=1 and substr(test,1,1)='^'
--------------------------
CREATE TABLE "JOBS"
("JOB_ID" VARCHAR2(10),
"JOB_TITLE" VARCHAR2(35),
"MIN_SALARY" NUMBER(6,0),
"MAX_SALARY" NUMBER(6,0),
"TEST" VARCHAR2(5)
) ;
--------------------------
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA
Insert into JOBS (JOB_ID,JOB_TITLE,MIN_SALA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.