how to use data in unix text file as input to an sql query from shell

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
how to use data in unix text file as input to an sql query from shell

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Using Shell Script to get data from text file	jermaine4ever	Shell Programming and Scripting	1	03-13-2009 08:58 PM
shell script to read data from text file and to load it into a table in TOAD	pallavishetty	Shell Programming and Scripting	1	10-31-2008 04:15 AM
How to fetch data from a text file in Unix	shikhakaul	Shell Programming and Scripting	4	01-25-2008 11:20 AM
Need Shell Script to upload data from Text file to Oracle database	chandrashekharj	Shell Programming and Scripting	6	03-26-2007 04:21 AM
How to input username on text file into finger command on shell script	Micz	Shell Programming and Scripting	3	11-08-2005 02:38 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

07-01-2009

rdhanek

Registered User

Join Date: Jun 2009

Posts: 74

how to use data in unix text file as input to an sql query from shell

Hi,
I have data in my text file something like this.

Code:

adams
robert
ahmed
gibbs

I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query to be updated into a text fiel so that i can mail the same as a report.
output expected :

Code:

Name   subject  marks
adams  maths   79
Robert Sceience 67
gibbs   maths    81

Thanks in advance

Last edited by Yogesh Sawant; 07-01-2009 at 08:37 AM.. Reason: added code tags

Bookmarks

Tags

shell, sql, unix

« awk - array elements as condition | getting basename inside awk script »

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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 10:24 AM.