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

This article mainly introduces the oracle command line formatting output of the commonly used commands, have a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

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-output the column name of C1 to c2. Thank you for reading this article carefully. I hope the article "what are the common commands of oracle command line formatting output" shared by the editor will be helpful to you. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.