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

First, start SQL*PLUS

1. Start menu 2, command line: Cmd, sqlplus3, running graphical interface: SQLPLUSW (supported by default in Windows) character interface: SQLPLUS (generic, Linux, Unix... )

Log in to SQLPLUS

To log in to other servers, you need to add @ server name after the user name, such as:

Third, direct landing method

Command line or run: Sqlplus username / password @ network service name Sqlplusw username / password @ network service name such as: Sqlplus

4. Quit SQLPLUS

Exit or Quit (clicking the "close" button directly is not a normal exit)

View the user's table and the structure of the table

1. View the user's table Select table_name from user_tables// User_tables: table owned by the user / / User_objects: all the objects owned by the user 2, view the table Select table_name from all_tables3 that all users can see, view the table structure of the user Desc [ribe] table_name/view_name

6. Edit the statements that have been entered

Ed [it]: re-edit L [ist]: lists the contents of the buffer

7. Call external scripts

1. Name of Start script with full path 2, @ script with full path name / / and start are basically the same / / @ command can be used in scripts (DOS batch or SHELL scripts of Linux or Unix) using / / Sqlplusw @ c:\ create.sql

Disconnect and switch users

Disconnect: disc [onnect] switch user: Connect] for example: conn scott/tiger, you can switch directly to scott user

IX. Set row width and page size

1. Set line width: set linesize number (number of characters), such as: set linesize 100, 2, set pagesize number (line), such as set pagesize 18, 3, display line width and page size: show linesize pagesize// can also write show linesize or show pagesize separately

10. Format columns (column)

1. Define column headings: Column column names head column headings

11. Set up automatic submission

Set autocommit on/off

12. Set up offline

1. Open offline Spool [path\] filename2, save the result, and end offline Spool off.

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.