Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help needed for shell scripting for oracle.
Top Forums Shell Programming and Scripting Help needed for shell scripting for oracle. Post 302421335 by fidelis on Friday 14th of May 2010 06:39:08 AM
Old 05-14-2010
Question Help needed for shell scripting for oracle.
Hi,

Please see contains both files created for automating the data from oracle through shell.

1)a_p.ksh
Code:
#!/bin/ksh
LOG=/home/A_P.log
MESSAGE=/home/MESSAGE_A_P.txt
mail_list=/home/AP_MAIL_LIST.txt
data=/home/spooled_A_P.log
echo "`date` Starting execution for A_P COUNT" > $LOG
 
RESULT=`$ORACLE_HOME/bin/sqlplus sa/'pwd'@im << EOF
        set echo on;
        set feedback on;
        @/home/A_P.sql
`
echo $RESULT >> $LOG
 
echo " `date` End of step generation of A_P COUNT has completed" >> $LOG
 
mailx -r"id@mail.com" -s " A P  Count `date` "  `cat $mail_list`<$MESSAGE
echo "mail has been sent" >> $LOG

2)spooled_A_P.log

Code:
SQL> #set serveroutput on;
SQL>
SQL> select count(*) from a_p;
  COUNT(*)
----------
    155
1 row selected.
SQL>
SQL> spool off;
 
SQL>

Now,
#)in this log file i only want to have Count ie 155 and not any other information.
##)in the script file how to pull data from this log file so that it gets into the body of the mail along with the contains of MESSAGE file and also want to write some text ie, THE count from A_P table is <data from log file> and message file contains signature.

Please help me out with this.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help needed in shell scripting......urgent

Dear friends, please help me to solve following problem. I'm running a frontend application from which i'll be invoking the shell script with arguments as given below -driver -w -p "ABC XYZ" -S -ds con -dn "abc xyz" i am getting $1=-driver $2=-w $3=-p $4="ABC $5=XYZ" $6=-S $7=-ds... (3 Replies)
Discussion started by: swamymns
3 Replies

2. Shell Programming and Scripting

Shell Scripting with Oracle...

Hi guys, I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any? Thanks for reading and in advance of posts, B14... (2 Replies)
Discussion started by: B14speedfreak
2 Replies

3. Shell Programming and Scripting

Help needed - shell scripting

I have a file that has text in the format below ABC / Some text / ABC / Some text / ABC / Some text / ABC / Some text / ABC / Some text / How can I seperate the text between a pair of 'ABC' into seperate files ??? any information would be of great help. Thanks (8 Replies)
Discussion started by: garric
8 Replies

4. Shell Programming and Scripting

SHell Scripting Help Needed

Dear All, I have an input file like this interface Serial10/0/7:11.1 point-to-point description CLIENT:SA_INSTITUTO ANGLO MEXICANO Sitio Metepec 104452:0,165 bandwidth 64 ip vrf forwarding INSTITUTO-ANGLO ip address 192.168.148.217 255.255.255.252 no ip directed-broadcast frame-relay... (2 Replies)
Discussion started by: cskumar
2 Replies

5. Shell Programming and Scripting

Help needed - ksh shell scripting

Hi all, i m new to Unix shell scripting(ksh) i have a requirement, can anyone help me out in this.. spec: i need to move all the files landing in "X" directory to "Y" directory automatically everyday at a particular time.. (5 Replies)
Discussion started by: subbu
5 Replies

6. Shell Programming and Scripting

Help needed in shell scripting

" how to write a script to send an error in a log file to a particular E-Mail ID " Can anyone help me in this ? Regards (3 Replies)
Discussion started by: himvat
3 Replies

7. Shell Programming and Scripting

Help needed with Shell scripting

Hi All, I need to split a flatfile based on it's first character, I am using the following script awk '{print > "TEST_substr($0,1,1).txt"}' PROVIDER.txt It is returning files TEST_1 and TEST_2 But I am not getting the .txt file extension. I need the files like TEST_1.txt and ... (1 Reply)
Discussion started by: sam35
1 Replies

8. Shell Programming and Scripting

Help needed in Korn Shell scripting

#! /bin/ksh while read line do if ] ; then echo "no data" continue; fi echo "performing operation on $line" done < prg.txt (3 Replies)
Discussion started by: Juhi Kashyap
3 Replies

9. Shell Programming and Scripting

UNIX shell scripting - help needed

Can anyone please help me to create the output file based on the attached input files using ksh script. I have 2 input files 1) inputfile1.txt 2) inputfile2.txt The script should accept 2 parametes: 1. Inputfile2.txt with 1-10,000 values ( sample file contains only 4 records) 2. Script... (5 Replies)
Discussion started by: vinus
5 Replies

LEARN ABOUT MINIX

log

LOG(1)							     cao-vlsi reference manual							    LOG(1)

NAME

       log - logical representations for boolean functions and utilities.

ORIGIN

       This  software  belongs	to  the  ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in
       Paris, France.

       Web : http://asim.lip6.fr/recherche/alliance/
       E-mail : alliance-users@asim.lip6.fr

DESCRIPTION

       log is a set of structures and functions that permits to manipulate several representations of  boolean	functions.  Several  programs  and
       libraries of the cao-vlsi cad tools rest on the log package. Three different kind of functions are available for:

       Hash table management

       Prefixed representation for boolean functions

       Ordered binary decision diagrams representation

EXAMPLE

       Let's suppose that actual mbk version is 'nnn'.	In order to use log, libMutnnn.a library must be called.
       makefile:
       HEADER = -I/labo/include
       LIB = -L/labo/lib -lMut -ltsh -labl -lbdd
       Each  library  can  be  called  separatly.  The	"log.h" header file must be inserted in the files that use the functions or the structures
       defined in a library.

SEE ALSO

       mbk(1), beh(1),

AUTHOR

       L. BURGUN salle 30 T. 55-65 Universite P&M Curie - 4 pl. Jussieu - FRANCE

THANKS

       Thanks to P. REMY, F. PETROT, P. ALLEGRE and N. DICTUS.

BUG REPORT

       This tool is under development at the ASIM department of the LIP6 laboratory.
       We need your feedback to improve documentation and tools.

ASIM
/LIP6							  October 1, 1997							    LOG(1)
All times are GMT -4. The time now is 11:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy