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

lmarbles

LMARBLES(6)							   Games Manual 						       LMARBLES(6)

NAME

       lmarbles - build figures out of colored marbles

SYNOPSIS

       lmarbles [--version]

DESCRIPTION

       You goal in the puzzle game lmarbles is to create a more or less complex figure out of single marbles within a time limit to reach the next
       level. Sounds easy? Well, there is a problem: If a marble starts to move, it will not stop until it hits a wall or another marble.

OPTIONS

       --version Show version information and exit.

FILES

       ~/.lgames/lmarbles.conf
	      Automatically generated configfile. This is not meant for human editing.

       /var/games/lmarbles/lmarbles.prfs
	      Global preferences and score file. Not for human editing.

BUGS

       Please report any bugs you find to Michael Speck <kulkanie@gmx.net>.

LICENCE

       lmarbles is covered by the GNU General Public License (GPL).

SEE ALSO

       barrage(6), lbreakout2(6), lgeneral(6), lpairs(6), ltris(6),

AUTHOR

       Michael Speck <kulkanie@gmx.net>

       This manual page was written by Uwe Hermann <uwe@hermann-uwe.de>, for the Debian GNU/Linux system (but may be used by others).

								 December 23, 2007						       LMARBLES(6)