Friday, July 5, 2013

Create an Alias for [ sqlplus "/as sysdba" ]

We can use this OS utility to create an alias of the commands we use very frequently:

Here, for example :

-bash-3.00$ cat .bash_profile

alias sqllogin='sqlplus "/as sysdba"'

-bash-3.00$

-bash-3.00$ sqllogin

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 5 07:24:46 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Hope this helps !!