Oracle Sqlplus sets the number of rows and width

1.Set the total number of lines displayed on the page

 

1)View the currentPagesize,The default value is14:

SqlplusCode

1.Show pagesize;

 

2)SetPagesizeSet100,You can display more than enough rows at a time.:

SqlplusCode

1.Set pagesize100;

 

 

2.Set the row width

 

1)View the currentLinesize,The default value is80:

SqlplusCode

1.Show linesize;

 

2)Set100Or wider.:

SqlplusCode

1.Set linesize100;

Modify the default value of page display and row

However, this method requires you to reset it the next time you enter SQL Plus, which is very troublesome. You can modify the default settings.

FindGlogin. SQL,

I installed Oracle 11. This file is located in D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ sqlplus \ admin. It is easy to find it by searching. Then open the file,

Get:

--

-- Copyright (c) 1988,200 5, Oracle. All Rights Reserved.

--

-- NAME

-- Glogin. SQL

--

-- DESCRIPTION

-- SQL * Plus global login "site profile" file

--