Home » SQL & PL/SQL » SQL & PL/SQL » related to page size
related to page size [message #199921] Thu, 26 October 2006 23:17 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
hello all,


SQL>select * from students order by dept_no;

SURNAME FIRST_NAME D_O_B STUDENT_NO DEPT_NO YEAR
---------- --------------- ------------ ---------- ---------- ----------
Monkhouse Robert Jones 05-23-1967 9 1 1
Hung-Sun Jimmy Lau 08-11-1969 12 3
Middleton Jane P 09-14-1971 13 3
Patel Mahesh 12-07-1970 4 2 1
Jones Gareth P Y 01-24-1970 5 1
Grimm Hans Johan 06-21-1971 10 1
Scott Gavin T J 02-20-1971 6 2
Ayton Phil J M A 07-13-1967 3 3 1
Brown Joseph P A 04-19-1970 8 3
Mulla Farook F U 10-24-1968 14 2
Duke Fitzroy 11-26-1970 1 4 2

SURNAME FIRST_NAME D_O_B STUDENT_NO DEPT_NO YEAR
---------- --------------- ------------ ---------- ---------- ----------
Al-Essawy Zaid M A 11-26-1970 2 4 2
Gyver Sue L J V 07-30-1968 11 2
Baker Abu-Mia 03-13-1971 7 1
Layton Hugh 11-16-1971 15 5 1

15 rows selected.

SQL>set pagesizes 100;
SQL>select * from students
2 order by dept_no;

SURNAME FIRST_NAME D_O_B STUDENT_NO DEPT_NO YEAR
---------- --------------- ------------ ---------- ---------- ----------
Monkhouse Robert Jones 05-23-1967 9 1 1
Hung-Sun Jimmy Lau 08-11-1969 12 3
Middleton Jane P 09-14-1971 13 3
Patel Mahesh 12-07-1970 4 2 1
Jones Gareth P Y 01-24-1970 5 1
Grimm Hans Johan 06-21-1971 10 1
Scott Gavin T J 02-20-1971 6 2
Ayton Phil J M A 07-13-1967 3 3 1
Brown Joseph P A 04-19-1970 8 3
Mulla Farook F U 10-24-1968 14 2
Duke Fitzroy 11-26-1970 1 4 2
Al-Essawy Zaid M A 11-26-1970 2 2
Gyver Sue L J V 07-30-1968 11 2
Baker Abu-Mia 03-13-1971 7 1
Layton Hugh 11-16-1971 15 5 1

15 rows selected.
Can u please tell me what was my earlier page size & upto what extend it changes my page size?

with regards
ashish
Re: related to page size [message #199924 is a reply to message #199921] Thu, 26 October 2006 23:50 Go to previous messageGo to next message
rameshuddaraju
Messages: 69
Registered: June 2005
Location: India
Member

In SQL * PLUS Default pagesize is 14 so your earlier pagesize is 14 thatswhy you got page headings for the next pages

That you can see as follows

SQL> show pagesize


Re: related to page size [message #199925 is a reply to message #199921] Thu, 26 October 2006 23:51 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
SQL> show pagesize
pagesize 14
SQL> set pagesize 999999999
SP2-0267: pagesize option 999999999 out of range (0 through 50000)
SQL>


Ross Leishman
Re: related to page size [message #199933 is a reply to message #199925] Fri, 27 October 2006 00:49 Go to previous message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
Thankyou very much Cool
thanks for your quick answering

with regards
ashish

[Updated on: Fri, 27 October 2006 00:50]

Report message to a moderator

Previous Topic: materialized view issues
Next Topic: Requesting PL/SQL procedure or upgrade
Goto Forum:
  


Current Time: Sun Dec 04 19:00:09 CST 2016

Total time taken to generate the page: 0.09072 seconds