sql query results in unix shell script Post: 302122393

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Executing a SQL query from a shell script

I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status.

2. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance!

3. Shell Programming and Scripting

how to use data in unix text file as input to an sql query from shell

Hi, I have data in my text file something like this. adams robert ahmed gibbs I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell. If you have code for similar scenario , please ehlp. I want the output of the sql query...

4. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

5. UNIX for Dummies Questions & Answers

executing SQL query using unix shell script

I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful.

6. Shell Programming and Scripting

SQL/Plus in a coprocess example. Also saves query results into shell variables

While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing. I recalled I made a coprocess example for folks at...

7. Shell Programming and Scripting

How to Assign SQL Query Results to Variables in Linux?

Hi, I am new to linux... How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me. Ex: SQL> Select * from EMP; O/P: Emp_No Emp_Name 1 AAA 2 BBB 3 CCC and I want expected...

8. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup...

9. Shell Programming and Scripting

How do I read sql query into shell script?

Hello All, I'm trying to put together a shell script that will: 1. connect to an oracle database 2. execute a query 3. save the output to a csv file I know that I can execute the sqlplus -s user/pass @dbsid and get logged in. What I would like to do is have my query in a separate text...

10. UNIX for Dummies Questions & Answers

Emailing results of a pl sql procedure from UNIX shell script

Hello All, I am writing the below unix script to email the result of a small pl sql procedure: #!/bin/bash ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME SQLPLUS=$ORACLE_HOME/bin/sqlplus sqlplus -s user/pass@Db_instance<<EOF set echo off set feedback off set pages 0...

LEARN ABOUT DEBIAN

gr_plot_int

GR_PLOT_INT(1)							   User Commands						    GR_PLOT_INT(1)

NAME

       gr_plot_int.py - plot integer binary data using GNU Radio

SYNOPSIS

       gr_plot_int: [options] input_filenames

DESCRIPTION

       Takes  a GNU Radio integer binary file and displays the samples versus time.  You can set the block size to specify how many points to read
       in at a time and the start position in the file. By default, the system assumes a sample rate of 1, so in time, each sample is plotted ver-
       sus  the  sample number. To set a true time axis, set the sample rate (-R or --sample-rate) to the sample rate used when capturing the sam-
       ples.

OPTIONS

       -h, --help
	      show this help message and exit

       -B BLOCK, --block=BLOCK
	      Specify the block size [default=1000]

       -s START, --start=START
	      Specify where to start in the file [default=0]

       -R SAMPLE_RATE, --sample-rate=SAMPLE_RATE
	      Set the sampler rate of the data [default=1.0]

SEE ALSO

       gr_plot_char(1)	gr_plot_const(1)  gr_plot_fft_c(1)  gr_plot_fft_f(1)  gr_plot_float(1)	 gr_plot_int(1)   gr_plot_iq(1)   gr_plot_psd_c(1)
       gr_plot_psd_f(1)  gr_plot_qt(1)	gr_plot_short(1)

gr_plot_int 3.5 						   December 2011						    GR_PLOT_INT(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Executing a SQL query from a shell script

Discussion started by: 98_1LE

2. Shell Programming and Scripting

query sql using shell script

Discussion started by: kingpeejay

3. Shell Programming and Scripting

how to use data in unix text file as input to an sql query from shell

Discussion started by: rdhanek

4. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Discussion started by: Nareshp