21 November 2010

My favorite alias

Aliasses are most useful tiny little means of making life easy on Linux.
One of my favorites is 'dba'

alias dba='sqlplus "/ as sysdba" @/home/oracle/scripts/login.sql'

with the login.sql:


This makes login most simple by typing dba and it looks like:

oracle@server01:~> dba

SQL*Plus: Release Production on Sun Nov 21 12:04:22 2010

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

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


What is your favorite alias?

No comments:

Post a Comment