Page size

[Sonia]

Hi folks,

When i query a big table in server manager, i am not able to see the top portion of the table. Is there any way to set the page size in server manager; why doesn't this set command work in svrmgr;
and again could anybody tell me how to do it in SQLPLUS.

Regards
sonia

[sjadhavdba]

svrmgrl is the utility to execute from dos prompt. so there is no need to use set command for that. simply increase the buffer size of that command window.

for sql plus use
set pagesize 1000 or whatever u want. either u can use the OPTION menu