2012年8月28日
小技巧----Replace the SQL> Prompt with the Current User Name
摘要： 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: 阅读全文
posted @ 2012-08-28 23:42 jefflu99 阅读(199) 评论(0) 推荐(0)
[Oracle Note] Oracle Shell Scripting[from forum]
摘要： 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 阅读全文
posted @ 2012-08-28 23:37 jefflu99 阅读(244) 评论(0) 推荐(0)