摘要:
Replace the SQL> Prompt with the Current User Nameby Jeff Hunter, Sr. Database AdministratorIn order to replace the SQL> prompt with the current user name, edit ORACLE_HOME/sqlplus/admin/glogin.sql and add:set sqlprompt '_user> 'Test the new SQL prompt:$ sqlplus scott/tigerSQL*Plus: 阅读全文
摘要:
This article presents some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN.WindowsUNIX and Linux (Method 1)UNIX and Linux (Method 2)UNIX and Linux (Returning values from SQL)WindowsTo run an SQL script using SQL*Plus, place the SQL alo 阅读全文
摘要:
In this article, I will write about resolving ORA-06508, ORA-04065, ORA-04068 errors.'ORA-06508: PL/SQL: could not find program unit being called’Thecause of the ORA-04068 is when a dependent object in a package is altered by a DDL statement. When packages are compiled, the copies of the package 阅读全文
摘要:
Oracle Shell ScriptingThis article presents some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN.WindowsUNIX and Linux (Method 1)UNIX and Linux (Method 2)UNIX and Linux (Returning values from SQL)WindowsTo run an SQL script using SQL*P 阅读全文