updating a column in oracle table using shell script

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
updating a column in oracle table using shell script

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
updating a column in a unix table for a particular row	thanuman	Shell Programming and Scripting	5	02-09-2009 06:52 PM
Updating table on UNIX server using SFTP	Pallavi_gondkar	UNIX for Dummies Questions & Answers	1	04-04-2008 06:47 AM
First Script: Query every table with column xxx.	Iniquity	Shell Programming and Scripting	1	02-06-2007 04:15 PM
Store return code of shell script in oracle table	sveera	Shell Programming and Scripting	3	05-04-2005 02:25 PM
update a oracle table using shell script	ann_124	Shell Programming and Scripting	2	12-18-2004 07:24 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

05-09-2005

sveera

Registered User

Join Date: Mar 2005

Location: INDIA

Posts: 60

updating a column in oracle table using shell script

Hi friends,
i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql
STATUS is the variable declared in the .profile
===============================
if [ $STATUS -eq 1 ]
sqlplus <<END
username/password@connectstring
@update.sql
commit;
but how to i pass the value of the $STATUS to the .sql ? this value has to go into a column in a table.
Please help
thanks in advance
Veera

Bookmarks

« How To Sort Array of Hashes ?? | ksh GUI commands »

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 06:32 AM.