Search Results

Hi

Thanks for the response.

I would like to Count the number of rows in the log table.if the count is greater than zero then I need to run certain Part of the code if not another part of the...

Hi all,

I have below code

sqlplus -s ext/exo@TIS << EOF
whenever sqlerror exit failure rollback;
set echo off
set head off
set serveroutput on
set termout on
set trimspool on
SPOOL...

Excellent Guru..Many Thanks

Dear all,

I would like to count the no;of word "INFORMATION" in a file called alt.lst and output to a unix variable INFORMATION.so to do this I wrote the below code

INFORMATION=echo...

Hi

I want to send the output of a spool file through mail.FYI..the spool file consists of output of a select comand with only 3 columns.The mail should be sent to a list of people .I didn't have...

I am able to run the shell.very much appreciated

Could you please let me know what was the error in the below line:

SQLCODE='cat $SPOOL_FILE | grep SQLCODE | awk -F '{print $2}' '

...

I am trying to get the data from oracle table to a variable I have tried the below code

#/usr/bin/sh
echo " I am in correct loop"
SPOOL_FILE=/app/scripts/alt.lst
sqlplus...