Home » SQL & PL/SQL » Client Tools » SQL worksheet (oracle 8.1)
SQL worksheet [message #291489] Fri, 04 January 2008 06:18 Go to next message
webadministrator
Messages: 45
Registered: October 2005
Member
hi, i am trying to perform a query that results in more than 600 records.In the output area, the titles of the solution is being repeated for every page as follows:

code_s code_r code_t
123 123 123
124 124 124
125 125 125
126 126 126
127 127 127
128 128 128
code_s code_r code_t
129 129 129
130 130 130
131 131 131
132 132 132
133 133 133
134 134 134
code_s code_r code_t
135 135 135
etc...

is there a way that "code_s code_r code_t" is written only at the beginning of the output and not repeated?

Thank you


Re: SQL worksheet [message #291490 is a reply to message #291489] Fri, 04 January 2008 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set pagesize 1000

Regards
Michel
Re: SQL worksheet [message #291491 is a reply to message #291489] Fri, 04 January 2008 06:39 Go to previous message
webadministrator
Messages: 45
Registered: October 2005
Member
thanks a lot
Previous Topic: How can i escape & in a query
Next Topic: SqlPrompt
Goto Forum:
  


Current Time: Tue Dec 06 06:48:56 CST 2016

Total time taken to generate the page: 0.18649 seconds