Getting started with sqlplus

the 1. Login: 1. sqlplus enters the user password according to the prompt, but there is no place to enter the database connection string, so you need to set ORACLE_SID in advance. the 2. sqlplus user/pass@db log in directly, the disadvantage is that the multi-user system may expose the password. the 3. sqlplus /nolog and then connect user/pass@db does not log in first, but starts sqlplus and then connects to the database. Compared with method 2, the password will not be exposed. the Question: When logging in, wrap user/pass@db in double quotes or single quotes, what is the difference between not wrapping it? the Answer: The non-wrapping method is only supported after oracle10g. www.2cto.com 2. Execution: 1. / A slash means that the statement in the execution buffer (just entered) must be on a single line, before oracle9i, there must be no space before /. 2. EXEC[UTE] stored procedure, execute the stored procedure (including function and package) in the database. 3. START|@ script file, execute the script file, if the script has no extension, automatically add .sql; if there is no path, it defaults to the current directory, or find it from the SQLPATH parameter. 4. @@ Script file, generally…