且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

查询结果中重复的列名

更新时间: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