Interested to Buy Any Domain ? << Click Here >> for more details...
ename empno deptno
amar 1 10
akbar 2 20
anthonny 3 30
jonathan 4 40
write a procedure to dispaly the column values ina row
separated by a
deleimiter
eg - input - select ename from emp '|' output -
amar|akbar|anthony|jonathan
input - select empno from emp '@' o/p - 1@2@3@4
input - select deptno from emp '/' o/p -
10/20/30/40
Pls answer this questn.
- 2 Answers
- 4992 Views
- I also Faced
- E-Mail Answers
Answer Posted / tina
create a function
--concat column values
create or replace function conactfunc (query_1 in varchar2)
return varchar2
is
v_return varchar2(4000);
v_query_concat varchar2(4000);
cur sys_refcursor;
begin
open cur for query_1;
loop
fetch cur into v_query_concat;
EXIT WHEN cur%NOTFOUND;
if v_return is null then
v_return := v_query_concat;
else
v_return := v_return || '@' || v_query_concat;
end if;
end loop;
return v_return;
end;
show_err;
and then call it
select hr.conactfunc('select region_name from regions') from dual;
O/P
Europe@Americas@Asia@Middle East and Africa
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is inner join in sql?
what are all different types of collation sensitivity? : Sql dba
What are joins in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Can you join views in sql?
What is nosql vs sql?
What is not in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is use of package in pl sql?
What is rtm stands for?
Can we use commit inside a trigger?
What does the sign mean in sql?
Are views faster than queries?
What are commit, rollback, and savepoint?
What is sap sql?
