Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Guidance needed for a typical shell script with sql query
Top Forums Shell Programming and Scripting Guidance needed for a typical shell script with sql query Post 302564266 by radoulov on Thursday 13th of October 2011 08:14:15 AM
Old 10-13-2011
Yes,
you've got an error because you need something different.

Code:
# these seem unnecessary ...
db_user=$DB_USER_NAME
db_pwd=$DB_PASSWORD
db_sid=$TWO_TASK

{ 
  printf 'set pages 0 feed off ver off head off echo off\n'
  printf "select   
    * 
  from   
    bus_event  
  where   
    bus_event_seq_nbr='%s';\n
  " $(<./seqnbr.txt)
  } | 
    sqlplus -s "$db_user"/"$db_pwd"@"$db_sid"

Or even:

Code:
{    
  printf 'set pages 0 feed off ver off head off echo off\n'    
  printf 'select   
    * 
  from   
    bus_event  
  where   
    bus_event_seq_nbr in ( %s );\n' $(
      printf "'%s'\n" $(<./seqnbr.txt) |
        paste -sd, -
        ) 
    } |
        sqlplus -s "$db_user"/"$db_pwd"@"$db_sid"

Last edited by radoulov; 10-13-2011 at 09:19 AM..
 

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. (3 Replies)
Discussion started by: 98_1LE
3 Replies

2. UNIX for Advanced & Expert Users

Connecting DB in the Shell Script to do SQL Query

Any link or example to write shell script for the Connecting Oracle for Quering through SQL thanks in advance ... Cheers !! Mehul Doshi (3 Replies)
Discussion started by: mehuldoshi
3 Replies

3. Shell Programming and Scripting

Executing Sql Query Using Shell Script

HI ALL i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job. (14 Replies)
Discussion started by: ragha81
14 Replies

4. Shell Programming and Scripting

executing a SQL query in shell script

Hi ALL, I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know. select query returns multiple values( say select name from emp) Thanks in advance LM (1 Reply)
Discussion started by: lijju.mathew
1 Replies

5. 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! (2 Replies)
Discussion started by: kingpeejay
2 Replies

6. Shell Programming and Scripting

$ symbol in sql query in shell script

Hi Team, Can you please help me to resolve this issue. Am unable to use this $ symbol in sql query in the shell script. For Example: # !/bin/sh export USER_NAME=XXX export PASSWORD=YYY export ORACLE_SID=xamdb echo $ORACLE_SID echo " Session Details ..." ... (1 Reply)
Discussion started by: indira_s
1 Replies

7. 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... (5 Replies)
Discussion started by: ramsavi
5 Replies

8. Shell Programming and Scripting

How to embed sql query into our shell script?

Hi I would like to embed a sql query in my shell script. Also, before any the sql query is executed, i would like to validate username and password. (1 Reply)
Discussion started by: arghadeep adity
1 Replies

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... (9 Replies)
Discussion started by: bbbngowc
9 Replies

10. Shell Programming and Scripting

Shell script to execute sql query.

Hi Experts, Need your support. Not able to use sql query alias in shell script. Could you please help me in finding right way to use alias with sql query in shell script. Below is the code i am using. #!/bin/bash sqlplus -s abc/abc@abc << EOF> bcd.csv set trimspool on select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies

LEARN ABOUT REDHAT

sdl_joystickopen

SDL_JoystickOpen(3)						 SDL API Reference					       SDL_JoystickOpen(3)

NAME

       SDL_JoystickOpen- Opens a joystick for use.

SYNOPSIS

       #include "SDL.h"

       SDL_Joystick *SDL_JoystickOpen(int index);

DESCRIPTION

       Opens a joystick for use within SDL. The index refers to the N'th joystick in the system. A joystick must be opened before it game be used.

RETURN VALUE

       Returns a SDL_Joystick structure on success. NULL on failure.

EXAMPLES

       SDL_Joystick *joy;
       // Check for joystick
       if(SDL_NumJoysticks()>0){
	 // Open joystick
	 joy=SDL_JoystickOpen(0);

	 if(joy)
	 {
	   printf("Opened Joystick 0
       ");
	   printf("Name: %s
       ", SDL_JoystickName(0));
	   printf("Number of Axes: %d
       ", SDL_JoystickNumAxes(joy));
	   printf("Number of Buttons: %d
       ", SDL_JoystickNumButtons(joy));
	   printf("Number of Balls: %d
       ", SDL_JoystickNumBalls(joy));
	 }
	 else
	   printf("Couldn't open Joystick 0
       ");

	 // Close if opened
	 if(SDL_JoystickOpened(0))
	   SDL_JoystickClose(joy);
       }

SEE ALSO

       SDL_JoystickClose

SDL
							      Tue 11 Sep 2001, 23:00					       SDL_JoystickOpen(3)
All times are GMT -4. The time now is 02:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy