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

synaptic

SYNAPTIC(8)						      System Manager's Manual						       SYNAPTIC(8)

NAME

       synaptic - graphical management of software packages

SYNOPSIS

       synaptic [options]

DESCRIPTION

       Synaptic  is  a	frontend  for the apt package managent system.	It allows you to perform all actions of the command line tool apt-get in a
       graphical environemnt. This includes installing, upgrading, downgrading	and removing of single packages or even upgrading your whole  sys-
       tem.

       A manual with detailed instructions can be found in the help menu of Synaptic.

OPTIONS

       Synaptic accepts all of the standard Gtk+ toolkit command line options as well as the following:

       -f, --filter-file=filename
	      specify an alternative filter settings file

       -i, --initial-filter=int
	      apply the filter with number int at startup

       -o, --option=option
	      set an internal option (experts only)

AUTHORS

       Synaptic  was  originally  developed  by  Alfredo  K.  Kojima  <kojima@conectiva.com.br>.  His last official release was 0.16. Michael Vogt
       <mvo@debian.org> took over his CVS version, that already included a nearly complete port to Gtk+. Michael completed the port and added  new
       features.  See  the  NEWS file for the user visible changes from that point on. Conectiva is still involved in the development of synaptic.
       Gustavo Niemeyer <niemeyer@conectiva.com> is doing a great deal of work.

       All development is done at http://savannah.gnu.org/projects/synaptic

       This manual page was originally written by Wybo Dekker <wybo@servalys.nl> and Michael Vogt <mvo@debian.org> and modified by Sebastian Hein-
       lein <sebastian.heinlein@campus.lmu.de>.

COPYRIGHT

       Copyright  (C)  2001-2004 Conectiva S/A

       Copyright  (C)  2002-2004 Michael Vogt

       There is NO warranty.  You may redistribute this software under the terms of  the  GNU General  Public License.	For more information about
       these matters, see the files named COPYING.

								    Mar 4, 2004 						       SYNAPTIC(8)