Shell script to query Oracle table Post: 302472736

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command...

2. Shell Programming and Scripting

Store return code of shell script in oracle table

Hi friends, I have to do the following things : 1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle...

3. Shell Programming and Scripting

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 sqlplus <<END...

4. Shell Programming and Scripting

shellscript.query Oracle table..populate in a text file

Hi Guys, I'm new to this forum as well as to UNIX shell scripting. I'm looking for a shellscript to query an Oracle database table and populate the result set of the query in a text file. Could you someone help me out with a sample code? Thanks, Bhagat

5. Shell Programming and Scripting

run oracle query remotly with shell script

hello how to run shell script to excute oracle queries on remote db ? i have tried as following sqlplus -s user/password@remote_server "select query;" but not working also this one sqlplus -s user/password@remote_server `select query;` not working :( i add this line to run another...

6. 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...

7. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea .

8. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

9. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database...

LEARN ABOUT DEBIAN

zapping_remote

ZAPPING_REMOTE(1)						  [FIXME: manual]						 ZAPPING_REMOTE(1)

NAME

       zapping_remote - sends commands to a running instance of Zapping

SYNOPSIS

       zapping_remote [-h] [-d NAME] [-i ID] [-v] [-x] [command]

DESCRIPTION

       zapping_remote is a small program to send Python commands to a running instance of Zapping. See the Zapping documentation for a list of
       commands.

       When the -x option is given zapping_remote can also send Xawtv commands, see the xawtv-remote(1) manual page for details.  Zapping also
       responds to xawtv-remote. This manual page refers to zapping_remote version 0.10.

OPTIONS

       -h
	   Prints usage information on stdout, then terminates the program.

       -d NAME
	   The X display to use.

       -i ID
	   The ID of the Zapping or Xawtv main window. When omitted zapping_remote tries to find it automatically.

       -v NUMBER
	   Debug level, default 0.

       -x
	   Switches to a xawtv-remote compatible mode, sending Xawtv instead of Python commands.

BUGS

       None known.

SEE ALSO

       zapping(1), zapping_setup_fb(1)

AUTHORS

       Zapping was written by Inaki Garcia Etxebarria, Michael H. Schimek (mschimek@users.sourceforge.net) and many contributors.

       This manual page was written by Michael H. Schimek.

[FIXME: source] 						    04/16/2012							 ZAPPING_REMOTE(1)