Shulou(Shulou.com)06/01 Report--

Description: SQL Plus can perform some database operations, just like using other database tools, but one drawback of SQL Plus is that the output is not formatted satisfactorily.

Let's get down to business. Press the Win+ r key, enter sqlplus or sqlplusw (for the difference between the two, you can find du Ma or Google), enter the user name: scott, password: tiger (of course, the password was not changed during installation). To log in, follow these steps:

Select * from emp;-the results are as follows:

Although the table emp has only more than ten rows of data, the query results are very lack of readability. Analyzing the results of the output shows that the output of each line of SQL Plus has a certain length, and if the line exceeds the length, a line break will be performed. In addition, when the output data exceeds a certain amount of data, it will also be paged.

1. Specify the length of the row

The default length of the SQL Plus output line is 80, and you can reset the length of the line through the set command.

2. Specify the size of the page

When processed according to step 1, the displayed data is somewhat readable, but 14 records are separated into two pages. If you want to set the number of records displayed per page, it is another property of SQL Plus: pagesize.

(note: pagesize counts from the first line of the output, and SQL Plus has a blank line at the beginning of each page, taking into account the column name and the separator between the column name and the data.) the setting method is as shown in the figure:

If you have any questions, please leave a message.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.