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

10 More Discussions You Might Find Interesting

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

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

3. Shell Programming and Scripting

run sql query via perl script

Hello, If I run this command on the server it works. # dbc "update config set radio_enabled = 0;" how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line. #!/usr/bin/perl #database path $dbc='/opt/bin/psql -Userver...

4. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

I need to run sql script from shell script which takes the input from a file and contents of file will be like : 12345 34567 78657 and query will be like : select seq_nbr from bus_event where event_nbr='12345'; select seq_nbr from bus_event where event_nbr='34567'; select seq_nbr...

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

6. Shell Programming and Scripting

Korn Script to connect and query oracle database

I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error: ERROR: ORA-01017: invalid username/password; logon denied...

7. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that...

8. Shell Programming and Scripting

Shell script to run sql query having a long listing of parameters

Hi, I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script. The scenario is like.... Suppose I have a file abc.txt that has the card numbers..it could be in thousands.. then I need to fire a query like ...

9. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way

10. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET...

LEARN ABOUT DEBIAN

otfdump

OTFDUMP(1)							   User Commands							OTFDUMP(1)

NAME

       otfdump - otfdump

DESCRIPTION

	      otfdump - convert otf traces or parts of it into a human readable, long

	      version

	      Options:

       -h, --help
	      show this help message

       -V     show OTF version

       -f <n> set max number of filehandles available (default: 50)

       -o <file>
	      output file if the ouput file is unspecified the stdout will be used

       --num <a> <b>
	      output only records no. [a,b]

       --time <a> <b> output only records with time stamp in [a,b]

       --nodef
	      omit definition records

       --noevent
	      omit event records

       --nostat
	      omit statistic records

       --nosnap
	      omit snapshot records

       --nomarker
	      omit marker records

       --nokeyvalue
	      omit key-value pairs

       --fullkeyvalue show key-value pairs including the contents
	      of byte-arrays

       --procs <a>
	      show only processes <a> <a> is a space-seperated list of process-tokens

       --records <a>
	      show  only  records  <a>	<a> is a space-seperated list of record-type-numbers record-type-numbers can be found in OTF_Definitions.h
	      (OTF_*_RECORD)

       -s, --silent
	      do not display anything except the time otfdump needed to read the tracefile

otfdump 1.10.2							     May 2012								OTFDUMP(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

run oracle query remotly with shell script

Discussion started by: mogabr

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Discussion started by: balaeswari

3. Shell Programming and Scripting

run sql query via perl script

Discussion started by: sureshcisco

4. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

Discussion started by: rkrish