OraFAQ Forum: Client Tools » Reporting in Oracle............

Home » Other » Client Tools » Reporting in Oracle............

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

Reporting in Oracle............ [message #245086]

Fri, 15 June 2007 02:29

lokhande.dinesh29
Messages: 36
Registered: May 2007

Member

Hi All,

I want to display the result in oracle from .sql file as below ...can any try to help me on that ASAP

E.g.
ttitle right "Page" format 999 sql.pno
select eno,ename from emp;
Page 1
ENO Ename
----------------------
10 Lee

Page 2
ENO Ename
----------------------
20 chung

Means each tuple or row should come on new page.

Regards,
Dinesh

Report message to a moderator

Re: Reporting in Oracle............ [message #245098 is a reply to message #245086]

Fri, 15 June 2007 03:05

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

INCLUDE
set pages 1

in your code

Report message to a moderator

Re: Reporting in Oracle............ [message #245102 is a reply to message #245098]

Fri, 15 June 2007 03:13

lokhande.dinesh29
Messages: 36
Registered: May 2007

Member

but it skips the column heahing from each page......?

Report message to a moderator

Re: Reporting in Oracle............ [message #245110 is a reply to message #245102]

Fri, 15 June 2007 03:35

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

set pagesize 2 (1 for header, 1 for data)

Regards
Michel

Report message to a moderator

Re: Reporting in Oracle............ [message #245114 is a reply to message #245086]

Fri, 15 June 2007 03:44

lokhande.dinesh29
Messages: 36
Registered: May 2007

Member

& if suppose, i want to display each row into new page & page length should be of size 60........then how it is possible?

Report message to a moderator

Re: Reporting in Oracle............ [message #245118 is a reply to message #245114]

Fri, 15 June 2007 03:54

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

set pages 60
select empno, ename||rpad(chr(10),58,chr(10)) from emp;

Regards
Michel

[Updated on: Fri, 15 June 2007 03:55]

Report message to a moderator

Previous Topic:	SQL+ login headache
Next Topic:	ORA-01012: not logged on

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 12 10:36:06 CDT 2025