更新时间:2023-01-19 15:15:52
之所以会获得这种效果,是因为页面大小小于返回的行数.默认值为14.如果将其设置为大于行数的值,则不会插入其他标题.您可以使用以下命令在sql * plus会话期间设置页面大小:
You get this effect because the page size is less than the number of rows returned. The default is 14. If you set it to a value greater than the number of rows, no additional headers will be inserted. You can set the pagesize during a sql*plus session with this command:
set pagesize n
其中,n是行数.因此,将其设置为200:
where n is then number of rows. So to set it to 200:
set pagesize 200