comparison of strings in unix shell scripting

piscean_n · #1 (**permalink**) 01-11-2008

Hi

Code:

STORAGE_TYPE=$1

echo "########### SQL SESSION STARTED ###########"


VALUE=`sqlplus -S /nolog << THEEND

connect tcupro/tcupro_dev@bdd1optn 
SET SERVEROUTPUT ON
DECLARE
        V_STORAGE_TYPE   varchar2(3);
         V_ERR_MSG  varchar2(255) ;
	 V_LOG_LEVEL varchar2(200);
BEGIN

  V_STORAGE_TYPE :=  '$STORAGE_TYPE';
  V_ERR_MSG := 'SUCCESS';
  V_LOG_LEVEL := 'DETAIL';
dbms_output.put_line(V_STORAGE_TYPE);
  TCUPRO.TCU_PURGE_TABLES_DUP(V_STORAGE_TYPE, V_ERR_MSG,V_LOG_LEVEL);
dbms_output.put_line(V_ERR_MSG);

END;
/
EXIT;
THEEND`


echo $VALUE >./logs/TCU-`date '+%Y%m%d-%H%M%S'`-PURGE.log

jim mcnamara · #2 (**permalink**) 01-11-2008

Code:

echo $VALUE >./logs/TCU-`date '+%Y%m%d-%H%M%S'`-PURGE.log
echo "$VALUE" | grep -q 'SUCCESS' 
return $?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Returning Strings from C program to Unix shell script	venkatesh_sasi	High Level Programming	24	11-28-2007 04:48 AM
Comparison of 2 strings	Retribution	Shell Programming and Scripting	2	12-06-2006 08:35 AM
difference between AIX shell scripting and Unix shell scripting.	haroonec	Shell Programming and Scripting	2	04-12-2006 09:12 AM
Returning Strings from C program to Unix shell script	satguyz	High Level Programming	11	12-30-2005 03:41 PM
How to concatenate two strings or several strings into one string in B-shell?	fontana	Shell Programming and Scripting	2	08-26-2005 12:58 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by