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

partimaged-passwd

partimaged-passwd(8)				       Partition Image Server Configuration				      partimaged-passwd(8)

NAME

       partimaged-passwd - Manage partimaged user accounts

SYNTAX

       partimaged-passwd [-Dhl] username password
       partimaged-passwd [-Dhl] username

DESCRIPTION

       partimaged can either authenticate against local user accounts (This needs access to /etc/shadow. As this is a potential security risk this
       method is not recommended) or its own password database in /etc/partimaged/passwd.db. To simplify the management  of  the  partimaged  user
       database  this tool was written. It allows to easily add and remove users or list the users in the database. All users in this database are
       allowed to access the partimaged server.

OPTIONS

       -D username
	      Delete the specified user from the password file.

       -l     List users in password file and exit.

       -h     Output help information and exit.

FILES

       /etc/partimaged/passwd.db

AUTHORS

       Michael Biebl <biebl@debian.org>

SEE ALSO

       partimaged(8), partimagedusers(5), partimage(1)

Michael Biebl <;biebl@teco.edu>						0.1						      partimaged-passwd(8)