This part is not implemented yet, but it will come soon.
<p>
<button onclick="window.history.back();">Go Back To Previous Page</button>
<p>
<br>
<br>
<br>
Or you can look at my <a href=most_used_linux>Linux Site</a>
<h3>Test Sqlplus Result in Shell</h3>
<pre>
#!/bin/ksh
# while [ 1 ]; do date; ./dbspace_alert.sh; sleep 30; done
MY_COUNT=`sqlplus -s / as sysdba&lt;&lt;EOF
set pagesize 0 feedback off echo off term off verify off newpage 0 head off
ttitle off
select count(*) cnt from dba_resumable;
-- test select count(*) cnt from dba_tables;
EOF
`
echo $MY_COUNT|sed 's/ //g'

if [[ $MY_COUNT -eq 0 ]];
then
echo "ok"
else
echo "not ok"
echo "mydb has space issue"|mailx -r aaa.bbb.vipalert@ccc.com -s "mydb on myhost has space issue" aaa.bbb@ccc.com
fi
</pre>
<hr>
<br>
<pre>

# examples of while
=================
#!/bin/ksh

-- ---------------------------
i="1"
while [ $i -gt 0 ]
do
sqlplus  <<-EOF
myusername@$ORACLE_SID/$PASSWORD
@@my_prog.sql
EOF
DATE=`date | cut -c 1-19`
        echo "Process Completed at " $DATE
        read
        i=`grep  "ORA-01555" my_prog.prt |wc -l`
done
-- -------------------------

# ********* commented_for_accidental_run ************
## remove all empty directories, commented out for accidental run
##!/bin/ksh
#cnt=`find . -type d -print | nawk -F"/" 'BEGIN{ level = 0 } { if (NF > level) {level = NF} } END{ print level }' \
#` while [ $cnt -gt 0 ] do \
#  for dirname in  `find . -type d ` \
#  do
#    file_cnt=`ls -1 $dirname | wc -l`
#    if [ $file_cnt = 0 ]
#    then
#      echo " $dirname is empty ";
#      rmdir $dirname
#    fi;
#  done
#  cnt=$(($cnt-1))
#done
# ************

# remove directory under some pattern
#commented_for_accidental_run find /../mydir -mtime +130 -name "filename.mysuffix" -exec /bin/rm -f {} \;
or
#commented_for_accidental_run find . -name "*.aud" -mtime +170 -exec rm {} \;

************

For making the replacement in all files in the current directory

#commented_for_accidental_run perl -p -i -e "s/PATTERNA/PATTERNB/g"  *

And then to search and make changes in files in the current and all sub directories:

#commented_for_accidental_run find . -type f -print | xargs perl -p -i -e "s/PATTERNA/PATTERNB/g"

# -- -------------------------

=====================================================
Function
sum(){
 s=`expr $1 + $2`
 return $s
}
sum $1 $2 || total=$?
echo $total

=====================================================
# Rename file without its extension

#There are lots of ways to accomplish this ... one of them is:

for fname in `ls *.log`
do
  fname=${fname%\.log}
  echo $fname
done
=====================================================
Using bc I can do this;
# bc
scale=4
50 / 100
.5000
quit

But, how to get this value, .5 in a script? When I script this, the script returns a 0, not a .05.

I'm using ksh at the moment.


VarName=$(bc <<EOF
scale=4
50/100
EOF)

==============================================

var=test.india.co
var1=test.india
echo ${var%.*}
output will be     =  test.india
echo ${var1%.*}
output will be     =  test
=========================================
a_flag=0
while getopts :abc opt
do
   case $opt in
     a) a_flag=1 ;;
     b) : .... ;;
     c) : ... ;;
   esac
done

if [ $a_flag -eq 0 ]
then
    exit 2
fi
=========================================

I know there is a simple way to do this but i cannot figure it out for the
 life of me :
I process some text and end up with a variable whose contents are :
MY_VARIABLE="abc def ghi jkl abc def ghi"
I want to process the variable $VARIABLE to output only the unique field
 which would be jkl since all of the

Solution
echo $MY_VARIABLE | tr " " "\n" | sort | uniq -u

echo $MY_VARIABLE | tr " " "\n" | sort | uniq -c|grep 1

# sed command doesn't work, but tr command worked

echo $MY_VARIABLE | sed 's/ /\n/g' | sort | uniq -c | grep 1
What this does is to list the string, and replace the white space with a
character return(newline), sort the new list and count the appearance of
each new line which is a value in the original list.Then picks up those that
only appear once.

echo "string1:string2:string3:string4:string5" | sed s/:/\\n/g

=========================================

I am trying to get decimal value for following, but getting integer values only. All values are numeric values.
d1=((Dt1/Dt2))
example:getting only 2 not 2.5
dt=(5/2)=2
Please advise me.

Answer
=======
You could use bc - eg:
echo "2/3" > filea
V=`bc -l filea <<EOF
EOF
echo $V
The result is .66666666666666666666

== =================================
# -- -------------------------
</pre>