Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Shell script appending output of sql query

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell script appending output of sql query
# 8  
Old 03-20-2018
thanks Yoda but the second sql should execute based on the condition when satisfied else not..something like this

Code:
variable1=$ echo "set feed off
set pages 0
select status from t1 where id = 10;
exit"  | sqlplus -s scott/tiger@orcl > v_tmp.txt

if [[ $(cat v_tmp.txt) == 'COMPLETE' ]]; then
    echo "second sql"
  sqlplus -s /nolog << EOF
connect $conn_str;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET VERIFY OFF;
SET LINESIZE 100;
set tab off;
set trimspool off;
spool v_out.txt append
select 'Second SQL' from dual;
spool off;
exit;
EOF
fi
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies

2. 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... (8 Replies)
Discussion started by: Jaganjag
8 Replies

3. Shell Programming and Scripting

SQL Query in Shell Script output formatting

Hi All, #!/bin/ksh call_sql () { sql=$1 sqlplus -s $sqlparam_sieb <<EOF SET ECHO OFF; SET NEWPAGE NONE; SET SQLBL OFF; SET VERIFY OFF; SET LINESIZE 2000; SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies

4. Shell Programming and Scripting

Shell script to perform appending of .sql files

Hi, We are having multiple .sql files generated programatically which is not containing.. create or replace -- at the start and / -- at the end We need to append those .sql files with the above 2 statements at their respective positions. We will be really thankful to get responses... (6 Replies)
Discussion started by: Rami Reddy
6 Replies

5. Shell Programming and Scripting

SQL query in UNIX script - output in flat file

Hi, I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen. snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies

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

7. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

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

9. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated. my sql query provide output some thing like this - col1 col2 count ---- ---- ------ A B 10 c D 6 e... (8 Replies)
Discussion started by: pharos467
8 Replies

10. 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
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

oar-database

oar-database(1) 						   OAR commands 						   oar-database(1)

NAME

       oar-database - create/initialize/upgrade/reset/drop the oar database

SYNOPSIS

       oar-database --create  [OPTIONS]

       oar-database --drop    [OPTIONS]

       oar-database --setup   [OPTIONS]

       oar-database --reset   [OPTIONS]

DESCRIPTION

       Manage the oar database.

       --setup
	   Initialize/Upgrade an existing database.

       --reset
	   Reset an existing database.

       --create
	   Create and initialize a new database/user.

       --drop
	   Drop an existing database/user.

OPTIONS

   General parameters
       --conf=OAR_CONF_FILE
	   Define the oar configuration file to use. By default /etc/oar/oar.conf is used. This file doesn't exist, the default parameters for
	   each value are used.

       --update-conf
	   The database parameters given in the command line are writen to the OAR_CONF_FILE

       -h,--help
	   Display this help.

       -d,--debug
	   Display more information during the script execution

       -f,--force-sql
	   Force to resume the execution even if an sql instruction fails

       -y,--force-yes
	   This option will cause oar-database to continue without prompting if it is doins something potentially harmful

   Database admin parameters
       These parameters are only needed for database/user creation or removing.

       --db-is-local
	   For --create or --drop, this option tells that the database is local. oar-database can use local admin account to execute command
	   (useful for postgres).

       --db-admin-user=DB_ADMIN_USER
	   For --create or --drop, this option gives the privilegied user to use.

       --db-admin-pass=DB_ADMIN_PASS
	   For --create or --drop, this option gives the privilegied user pass to use.

   SQL parameters
       By default, if not specified, all the sql parameters are taken from the OAR_CONF_FILE. It is preferable to set these values directly to
       this file.

       --db-type=DB_TYPE
	   The type of the SQL database. It can be currently, mysql or Pg (for postgresql).

       --db-user=DB_USER
	   Connect to the database as the user DB_USER instead of the one given in OAR_CONF_FILE. By default, if OAR_CONF_FILE doesn't specify a
	   user, it is oar.

       --db-pass=DB_PASS
	   Connect to the database with the password DB_PASS instead of the one given in OAR_CONF_FILE.

       --db-host=DB_HOST
	   Connect to the database on the host DB_HOST, By default, if OAR_CONF_FILE doesn't specify a host, it is localhost.

       --db-port=DB_PORT
	   Connect to the database on the port DB_PORT, By default, if OAR_CONF_FILE doesn't specify a port, the value depend on the DB_TYPE. if
	   DB_TYPE is mysql, DB_PORT is 3306. If DB_TYPE is postgresql, DB_PORT is 5432.

       --db-name=DB_NAME
	   Connect to the database on the host DB_HOST, By default, if OAR_CONF_FILE doesn't specify a database name, it is oar.

       --db-ro-user=DB_RO_USER
	   same as --db-user except that it is for the read only access.

       --db-ro-pass=DB_RO_PASS
	   same as --db-pass except that it is for the read only access.

EXAMPLES

   Mysql
       First you need to specify the sql parameters in /etc/oar/oar.conf. These parameters will be used by oar-database.

       To create a new database (assuming that the sql root password is PASS):

       oar-database --create --db-admin-user root --db-admin-pass PASS

       To upgrade an existing database:

       oar-database --setup

   Postgresql
       First you need to specify the sql parameters in /etc/oar/oar.conf. These parameters will be used by oar-database. Then if your postgresql
       database is on the local system, you can use the option --db-is-local (otherwise, the procedure is the same as Mysql). So oar-database will
       use the postgres unix user to administrate the database (you need privilegied access to the local system).

       To create a new database:

       oar-database --create --db-is-local

       To upgrade an existing database:

       oar-database --setup

   Advanced usages
       To make some tests or to administrate several databases, you can also specify the sql parameters on the command line. For example:

       oar-database --create --db-type=Pg --db-host=HOST 
		      --db-user=oar --db-pass=PASS 
		      --db-admin-user=ADMIN_USER --db-admin-pass=ADMIN_PASS

       will create the oar database and the oar user on the postgresql system hosted by HOST. The user ADMIN_USER must have the right to create
       new databases and new roles on this system.

FILES

       /usr/lib/oar/database/mysql_structure.sql, /usr/lib/oar/database/pg_structure.sql
	   SQL instructions for creating the structure of the oar database.

       /usr/lib/oar/database/mysql_default_admission_rules.sql, /usr/lib/oar/database/pg_default_admission_rules.sql
	   SQL instructions for inserting the default admission rules in the oar database.

       /usr/lib/oar/database/default_data.sql
	   SQL instructions for inserting the default data in the oar database.

       /usr/lib/oar/database/mysql_reset_structure.sql, /usr/lib/oar/database/pg_reset_structure.sql
	   SQL instruction for emptying an existing oar database.

       /usr/lib/oar/database/mysql_structure_upgrade_*.sql, /usr/lib/oar/database/pg_structure_upgrade_*.sql
	   SQL instructions for upgrading an existing database.

oar-database							    2012-06-26							   oar-database(1)