Monday, August 27, 2007

Oracle Procedure Source code from Dictionary

SELECT to_char(text)
FROM user_source
WHERE type IN ('PACKAGE' ,'PROCEDURE','TRIGGER')

Sunday, August 19, 2007

Wednesday, August 15, 2007

Getopts with bash


#!/bin/sh

usage()
{
echo "Usage: $0 -a all -b ball -c -d -e";
exit 1;
}

if [ $# -lt 1 ] ; then
usage;
fi

# ":" decides which options require an argument
# In the example below options "a" and "b" will require a value to be passed along
while getopts a:b:cde opt
do
case "$opt" in
a) echo "hello $OPTARG";;
b) echo "hello $OPTARG";;
c) echo "c is selected";;
d) echo "d is selected";;
e) echo "e is selected";;
\?) usage;;
esac
done