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

Set linesize (line) sets the maximum line width of the sqlplus output-- the maximum number of rows of the set pagesize setting page

Set newpage sets the number of blank lines between pages

File input and output commands for spool sqlplus screen

Edit can also use ed. Exe to edit specified files using a custom editor. It can be directly used / executed after modification.

Save saves the most recent sql statement of the current session to the specified file

Host returns to the operating system environment, similar!

Start or @ execute the command in the file

Edit uses a custom editor to edit the specified file

Editor in define_editor Custom sqlplus

Exit or quit exits sqlplus

Column

Column is the most practical command in sqlplus. In many cases, the column width of the sql statement output is not appropriate, which affects the view.

Use this command to change the width and title of the specified column in the select statement. Most of the time, we can abbreviate column to col.

However, there are two main uses:

? Modify column width

Column C1 format A20-adjust the maximum width of column C1 (character type) display to 20 characters

Column C1 format 9999999-adjust the maximum width of column C1 (numtype) display to 7 characters

? Modify column headings

Column C1 heading c2-- outputs the column name of C1 as c2

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.