Visit Our UNIX and Linux User Community


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


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Run SQL thru shell script: how to get a new line when run sql query?
# 1  
Old 06-18-2012
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 Smilie

What should I do? I'm not sure that I did set the statements correctly.
Please kindly to suggest me ;(

Thanks~

============================================
Code:
============================================
Code:
#!/bin/bash
 
suc_num=`$PATH/sqlplus -s xx/yyy@service_name << !
set echo off
set feedback off
set heading off
set pagesize 0
set newpage 0
set wrap on
@success.sql
commit;
exit;
!`
 
echo $suc_num

=====================================================
Result: (Should have 3 columns: DateTime[yyyy-mm-dd hh]|The Number|ElementName)
=====================================================
Code:
2012-06-17 10 2 HLR_DUMMY 2012-06-17 11 1 HLR_DUMMY 2012-06-17 12 2 HLR_DUMMY 2012-06-17 15 1 HLR_DUMMY 2012-06-17 17 1 HLR_DUMMY 2012-06-17 00 102 aaa1 2012
-06-17 01 33 aaa1 2012-06-17 02 20 aaa1 2012-06-17 03 344 aaa1 2012-06-17 04 10 aaa1 2012-06-17 05 19 aaa1 2012-06-17 06 35 aaa1 2012-06-17 07 76 aaa1 2012-06-17 08 222 aaa1 2012-06-17 09 425 aaa1 2012-06-17 10 4211 aaa1 2012-06-17 11 552 aaa1 2012-06-17 12 994 aaa1 2012-06-17 13 1077 aaa1 2012-06-17 14 844 aaa1 2012-06-17 15 779 aaa1 2012-06-17 16 892 aaa1 2012-06-17 17 932 aaa1


Last edited by pludi; 06-18-2012 at 04:39 PM..
# 2  
Old 06-18-2012
Code:
echo "$suc_num"

Put double quotes around the variable. Hope this will resolve your issue.
This User Gave Thanks to pravin27 For This Post:
# 3  
Old 06-18-2012
Oh gosh!!! O[]O!!!Really easy!

A million thanks, prvin27. It's okay now. Smilie)

Previous Thread | Next Thread
Test Your Knowledge in Computers #566
Difficulty: Easy
Many programming languages use two ampersands, a && b to denote the logical And operator.
True or False?

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Run sql query after ssh in UNIX

I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2 Can anybody please help. I need to run queries on server2 itself.:confused: Below is the test script... (10 Replies)
Discussion started by: shruthimithra
10 Replies

3. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies

4. 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 ... (12 Replies)
Discussion started by: vsachan
12 Replies

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

6. 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... (1 Reply)
Discussion started by: rkrish
1 Replies

7. Shell Programming and Scripting

Run Sql plus in shell script

Hello, I want to connect to ssh, run a query, and store that into a variable in the shell script. Also I need to pass the variable back to php to display the query results. I have created a public/private key pair for ssh connection and that is working fine. Also I am able to run query in the... (8 Replies)
Discussion started by: shekhar2010us
8 Replies

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

9. Shell Programming and Scripting

shell script to run .sql files

hi Friends, Please help me in writing shell script to run list of sql files. database is Oracle 9i, unix os is solaris Requirement is 1. sql file must take two inputs a)feed id and b)business date 2.shell script must out put .xls or .csvfile as out put without trimming any column name and... (1 Reply)
Discussion started by: balireddy_77
1 Replies

10. Shell Programming and Scripting

How to run an SQL script inside a shell

How do I create a K Shell which would silently (without user input) logon to Oracle and run an SQL script? Any help will be greatly appreciated. Steve (1 Reply)
Discussion started by: stevefox
1 Replies

Featured Tech Videos