OraFAQ Forum: Server Administration » Regarding the Crosstab Query

Home » RDBMS Server » Server Administration » Regarding the Crosstab Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regarding the Crosstab Query [message #374965]

Mon, 16 July 2001 00:53

yuvarani
Messages: 1
Registered: July 2001

Junior Member

I want to print my sql query output in horizonta direction like
select emp_no from emp
1 2 3 4 5 6 .

Report message to a moderator

Re: Regarding the Crosstab Query [message #374975 is a reply to message #374965]

Mon, 16 July 2001 12:53

andrew again
Messages: 2577
Registered: March 2000

Senior Member

create or replace function emplist (max_emp_no IN number) return varchar2
is
elist varchar2(1000) := '';
begin
for e in ( select empno from emp where empno <= pmax_emp_no )
loop
elist := elist || e.empno || ' ';
end loop;
return substr(elist,1,length(elist)-1);
end;
/

select emplist(100)
from emp;

Also see... http://128.121.241.221/Pipelines/PLSQL/archives.htm#code16

Report message to a moderator

Previous Topic:	IN NEED OF SQL STATEMENT PLEASE
Next Topic:	Limit Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 12 13:21:33 CDT 2026