Several common commands in SQL Plus (3)

1.set linesize 300 (for a row of 300 characters)

Set Linesize can set the number of characters to be displayed on a line, by default 80 characters

2.L (list)

The last execution in the buffer can be displayed

3.run/r

The above three command functions are consistent, re-run the statements in the buffer

4.save

Save saves the last statement executed in the cache to a file
Example: Save E:\emp.sql

5.get

Get can put the SQL statements in the file into the buffer, with/or R or run, you can perform

6.ed (Edit)

Ed can use Notepad to edit content in the cache.

7. How to execute SQL scripts directly:

@e:\sql\yy.sql

Several common commands in SQL Plus (3)