sqlplus命令大全（Sqlplus command Daquan）.docVIP

sqlplus命令大全（Sqlplus command Daquan） Enter, enter sqlplus at the command prompt, and enter; The use of the SQL*PLUS command (Updated) 2006.01.01 update: Added The set command in 14) 16), 34 I 41 The use of the SQL*PLUS command Oracles sql*plus is a client tool for interacting with oracle. In sql*plus, you can run the sql*plus command and the sql*plus statement. We usually say DML, DDL, DCL statement is a sql*plus statement, which after the implementation, can be stored in a called SQL buffer in memory area, and can only save a recently executed SQL statement, we can modify the SQL statement in SQL to save buffer, then again, sql*plus is dealing with the database. In addition to the sql*plus statement, other statements executed in sql*plus are called sql*plus commands. After they are executed, they are not stored in the memory area of SQL buffer. They are usually used to format the output results to make statements. Here are some of the commonly used sql*plus commands: 1. execute a SQL script file SQLstart file_name SQL@ file_name We can save multiple SQL statements in a text file, so that when you want to execute all of the SQL statements in this file, you can use any of the above commands, which is similar to batch processing in dos. What is the difference between @ and @ @? @ is equal to the start command used to run a SQL script file. The @ command calls the current directory, or specifies the full path, or the script file that can be searched through the SQLPATH environment variable. This command uses the full path of the file in general that specifies the file to be executed, otherwise the specified file is read from the default path (which can be specified by the SQLPATH variable). @ @ used in SQL script file, used to illustrate the use of SQL script file and execute the @ @ @ @ files in the same directory, without specifying the full path to execute the SQL script file, nor from the path specified by the SQLPATH environment variable for SQL script file, the