Home » RDBMS Server » Server Administration » Regarding the Crosstab Query
Regarding the Crosstab Query [message #374965] Mon, 16 July 2001 00:53 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 07 16:33:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.