Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Query the table and return values to shell script and search result values from another files.
Top Forums Shell Programming and Scripting Query the table and return values to shell script and search result values from another files. Post 302804207 by Rami Reddy on Wednesday 8th of May 2013 07:22:40 AM
Old 05-08-2013
Query the table and return values to shell script and search result values from another files.
Hi,

I need a shell script, which would search the result values from another files.

1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.

could please explain about this.Below is the way i am using.

Code:
#!/bin/sh
export db_connection_url=apps/apps@VIS
ls -l ${XXHEX_TOP}/*.wft | awk '{ if ($1 !~ /^d/) {print $9;} }' > wft_file_list.txt
while read LINE
do
names=`sqlplus -s $db_connection_url <<EOF
set pagesize 0 feedback off verify off echo off serveroutput on time off timing off 
select distinct name
from error_log;
exit
EOF
`
FILENAME=`basename $LINE`
if [ $(echo ${FILENAME} | egrep -r "$name") -eq 1 ]; then
echo "file present"
else
echo "file not present"
fi
done <wft_file_list.txt

Thank you.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Korn Shell Script - Read File & Search On Values

I am attempting to itterate through a file that has multiple lines and for each one read the entire line and use the value then to search in other files. The problem is that instead of an entire line I am getting each word in the file set as the value I am searching for. For example in File 1... (2 Replies)
Discussion started by: run_unx_novice
2 Replies

2. Shell Programming and Scripting

How to pass pl/sql table values to shell script

Hello, i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies

3. Shell Programming and Scripting

Shell script to catch PL/SQL return values

Hello, I need some help from the experts on PL/SQL and Shell scripting. I need a shell script that runs a PL/SQL procedure and gets the values returned from the PL/SQL procedure into the shell variables. The PL/SQL procedure returns multiple values. I was able to assign a single return value... (1 Reply)
Discussion started by: Veera_Raghav
1 Replies

4. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the... (2 Replies)
Discussion started by: Bubnoff
2 Replies

5. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

6. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ... (1 Reply)
Discussion started by: barani75
1 Replies

7. Shell Programming and Scripting

Shell script to catch PL/SQL return values

I tried searching the forum for similar posts but its closed now. Would appreciate any help on this. I am trying to capture return value from a select query into a variable. DB is Oracle I am able to spool it to a file but I donot intend to use it. Here is my script that does not work ;) I... (27 Replies)
Discussion started by: monie2717
27 Replies

8. Shell Programming and Scripting

How to add values of two files and result in third file

Hi, I am new to shellscripting, I have two files as below File1: Abcdefg110111xyza000000600000000024.020000060000000000024.020000004660000000003.41000000000010000000100.000000000123 File 2:... (3 Replies)
Discussion started by: rajendrabujji
3 Replies

9. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

10. UNIX for Beginners Questions & Answers

Putting query result dynamically to one cell of table from shell

I have to send a data in mail table format.only one cell need to get dynamically from query. my code is like (echo '<table boarder="1"> echo '<tr><td>stock</td><td>/path</td><td>.........</td></tr>' echo '</table> )sendmail.. in ......... I am trying to get query result.By putting query... (2 Replies)
Discussion started by: meera_123
2 Replies

LEARN ABOUT DEBIAN

ideviceinstaller

ideviceinstaller(1)					      General Commands Manual					       ideviceinstaller(1)

NAME

       ideviceinstaller - Manage iDevice apps

SYNOPSIS

       ideviceinstaller [OPTIONS]

DESCRIPTION

       Allows to install, upgrade, uninstall, archive, restore and enumerate installed or archived apps on iDevices.

OPTIONS

   General options:
       -d, --debug
	      enable communication debugging.

       -U, --uuid UUID
	      target specific device by its 40-digit device UUID.

       -h, --help
	      prints usage information

   Commands:
       -l, --list-apps
	      list apps installed on the device.

	      Additional options:

	      -o list_user
		     list user apps only (apps installed by the user) This is the default.

	      -o list_system
		     list system apps only (apps available from the system firmware)

	      -o list_all
		     list all types of apps

	      -o xml print output in xml format (PList)

       -i, --install ARCHIVE
	      install app from a package file specified by ARCHIVE.

       -u, --uninstall APPID
	      uninstall app specified by APPID.

       -g, --upgrade APPID
	      upgrade app specified by APPID.

       -r, --restore APPID
	      restore archived app specified by APPID.

       -L, --list-archives
	      list archived applications on the device.

	      Additional options:

	      -o xml print output in xml format (PList)

       -a, --archive APPID
	      archive app specified by APPID.

	      Additional options:

	      -o uninstall
		     uninstall the package after making an archive

	      -o app_only
		     archive application data only

	      -o copy=PATH
		     copy the app archive to directory PATH when done

	      -o remove
		     only valid when copy=PATH is used: remove after copy

       -R, --remove-archive APPID
	      remove app archive specified by APPID.

AUTHOR

       This manual page was written by Martin Szulecki.

															       ideviceinstaller(1)
All times are GMT -4. The time now is 09:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy