SQL Plus/PL

One, SQL Plus is a user interface provided by Oracle. A command line similar to the operating system. Users can send commands to the database by entering commands in SQL Plus, and the database renders the processing results to the user via SQL Plus. is the interactive tool for databases and users.

SQL Plus has two modes, command-line mode, GUI mode, corresponding to two executable files.

command-line Mode login: Sqlplus username/password @ DB instance name

The output for each row of SQL Plus has a certain length, and if this length is exceeded, a line-wrapping operation is performed. Pagination is also performed when the number of rows in the output exceeds a certain number. Show Linesize View the length of the line, set linesize 150 sets the row lengths to 150. Show pagesize Query the number of rows per page,

Set pagesize 20 Sets the number of rows per page. Each page has a blank line at the beginning, one row for the column name, and the column name and the separating row between the data are counted.

SQL Plus if the volume of data is large, a scrolling screen may occur, you can log on as an administrator, set pause on setting the Suspend property is on, the query will be paused before the first page is returned, press Enter and the next screen will be displayed automatically.

Second, PL/SQL is the Oracle's procedural programming language, which defines a large number of grammars that users can follow to define blocks of code to complete complex database operations. These blocks can be stored as database objects, enabling code reuse. Block development work can still be done on the user tools SQL Plus.

The last line of the block is used/ended to execute the written PL/SQL program block.

SQL Plus/PL