UNIX for Dummies Questions & Answers

export ORACLE_HOME='/oracle/app/oracle/product/11.2.0.client'
export DATABASE='stc_irb_usr/stcirbusr_stctest12@stctest12'
export FGRED="\033[31m"
export FGGREEN="\033[32m"
export BOLD="\033[1m"
export NORMAL="\033[m"
echo "Started counting number of records with trailing/leading spaces..."
 
#For counting trailing spaces block 
 
echo "\
set pagesize 0
select count(*) from itemtranslation
where regexp_like(translated_item, '^[ ]+.*');" |
sqlplus -s $DATABASE | read trail
echo -e $FGGREEN $BOLD "Number of ITEMTRANSLATION records with trailing spaces is:" $NORMAL
echo -e $FGRED $BOLD "$trail" $NORMAL
echo "\
set pagesize 0
select count(*) from itemtranslation where regexp_like(translated_item, '.*[ ]+$');" |
sqlplus -s $DATABASE | read lead
echo -e $FGGREEN $BOLD "Number of ITEMTRANSLATION records with leading spaces is:" $NORMAL
echo -e $FGRED $BOLD "$lead" $NORMAL

if [ $v_count_1 = 0 ]
then
echo "something1"

elif [ $v_count_1 -gt 0 ]
then
echo "something2"

if [ $v_count_1 = 0 ]

if [ "$v_count_1" = 0 ]

#!/bin/sh
v_count_1=0
if [ "$v_count_1" = 0 ]
then
echo "something1"
else
echo "vicky"
fi

if [ "$v_count_1" == "0" ]

if [ $v_count_1 -eq 0 ]

#! /bin/ksh

. ./path/to/oracle-users/home/.ora_env

<rest of the script>