Home » SQL & PL/SQL » Client Tools » Reporting in Oracle............
icon5.gif  Reporting in Oracle............ [message #245086] Fri, 15 June 2007 02:29 Go to next message
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
Re: Reporting in Oracle............ [message #245098 is a reply to message #245086] Fri, 15 June 2007 03:05 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
INCLUDE
set pages 1

in your code
Re: Reporting in Oracle............ [message #245102 is a reply to message #245098] Fri, 15 June 2007 03:13 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member

but it skips the column heahing from each page......?
Re: Reporting in Oracle............ [message #245110 is a reply to message #245102] Fri, 15 June 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set pagesize 2 (1 for header, 1 for data)

Regards
Michel
Re: Reporting in Oracle............ [message #245114 is a reply to message #245086] Fri, 15 June 2007 03:44 Go to previous messageGo to next message
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?
Re: Reporting in Oracle............ [message #245118 is a reply to message #245114] Fri, 15 June 2007 03:54 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sun Dec 11 00:27:42 CST 2016

Total time taken to generate the page: 0.12356 seconds