SQL Script Amended sqlplus GLogin Script

Updated: 02-Jun-2005
Version: 1.0

Description

This glogin scripts includes the SID name and the database username you are logged into. Good idea if you are using multiple databases

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

SET TERMOUT OFF 
COLUMN D22 NEW_VALUE VAR 
SELECT USERNAME D22 FROM USER_USERS; 

SET TERMOUT ON 

SET SQLPROMPT "&_CONNECT_IDENTIFIER &&VAR>" 

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links