Sponsored Content
Full Discussion: Need Suggestion
Top Forums Shell Programming and Scripting Need Suggestion Post 302694553 by bhupinder08 on Friday 31st of August 2012 02:59:55 AM
Old 08-31-2012
Need Suggestion

Hi,

I have the requirement to run multiple SQLs against database running on a server and save the output of SQL executed to a log.

I thought about writing a Function in sh that will take file name as argument and function should return the SQL output to calling program. E.g.
Code:
function Run_SQL {
    vSQL=$1

    vSPOOL=`sqlplus -L -s dbuser/dbuser@$ORACLE_SID<<EOF
		set pagesize 200 feedback off lines 100
		@@$SCRIPT_HOME/${vSQL}
        exit;
EOF`

echo $vSPOOL
}

This function I am planning to call multiple times for all SQL files that need to be executed one by one.

Can someone please suggest if the approach I used is correct or is there a better way to achieve it. I am a novice to shell scripting.

Thanks a lot for your time.
Moderator's Comments:
Mod Comment Please view this code tag video for how to use code tags when posting code and data.

Last edited by vbe; 08-31-2012 at 05:21 AM.. Reason: replaced fonts by code tags
 

9 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

Suggestion

As I was just pondering to myself I relized that emergency's do happen and there are times when people need an anwser to their problem ASAP. So what i was thinking why not add a live chat to this board this way people could chat amongst each other in real time. I know this could be done with a... (1 Reply)
Discussion started by: tovsky
1 Replies

2. Programming

I want a suggestion

I am a student and I love the computer very much , especially in programming. However I know little about programming . I don't know which I should learn (JAVA and C++). Would you like to give me a suggestion ? Thanks! (6 Replies)
Discussion started by: camel
6 Replies

3. Shell Programming and Scripting

Need your suggestion please..

can anyone rite here guide me. i want to know which reference books that all of you recommended for C Shell dummies like me...(beginner) (1 Reply)
Discussion started by: unknown2205
1 Replies

4. Shell Programming and Scripting

need your suggestion

Hi all: I need your suggestion about how to making this script Purpose:- Monitor log for the system OS: Unix Sun Solaris 10 Hold oracle database 10 g Life time for the system cycle to 48 hours the system working as the follow 1- the system is divided into three steps 2-... (0 Replies)
Discussion started by: dellsh
0 Replies

5. Post Here to Contact Site Administrators and Moderators

Suggestion

Can we have a forum that is dedicated to topics concerning power management ? It'd be great to have a few moderators to address these issues concerning the power-management. More-so-ever since research related to power management at the OS level is kicking up a lot of dust and becoming a hot area... (7 Replies)
Discussion started by: vishwamitra
7 Replies

6. UNIX for Dummies Questions & Answers

OS suggestion

Hello, I'm working on a Linux 2.6.32-33-server (Ubuntu 4.4.3). I typed in man -k package and got e.g. apt I typed in apt --help and got: The program 'apt' is currently not installed. You can install it by typing: sudo apt-get install openjdk-6-jdkI don't understand where this... (2 Replies)
Discussion started by: daWonderer
2 Replies

7. Shell Programming and Scripting

Any suggestion?

Hi folks, Any good suggestion concerning this BASH search script? #Any good suggestions for this simple search shell? #================================ #!/bin/bash clear echo "Enter File Name for search" echo read filename locate $filename if ; then echo No such file... (1 Reply)
Discussion started by: leo_ultra_leo
1 Replies

8. IP Networking

Experts - Need suggestion

I'm searching to learn linux coding for a month but no clear about the where to start . Right now i'm in networking but not much interested in this maintenance jobs . I'm looking to create my own product in wireless network and also having idea about gadget that can be useful for students . But i... (1 Reply)
Discussion started by: Cholasivam
1 Replies

9. Post Here to Contact Site Administrators and Moderators

Regarding suggestion

Hello Admin/moderators Team, Greetings !! This is regarding a suggestion which may help our forum if this is possible. Thanks, R. Singh "GOD helps those who help themselves" (2 Replies)
Discussion started by: RavinderSingh13
2 Replies
MONGO(1)							  Mongo Database							  MONGO(1)

NAME
mongo - the Mongo command-line tool SYNOPSIS
mongo [OPTIONS] [DB_ADDRESS] [FILE+] DESCRIPTION
mongo is a JavaScript shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively, JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey. Database output is dis- played in JSON format. If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting. EXAMPLES
mongo start the shell, connecting to the server at localhost:27017 and using the test database mongo foo start the shell using the foo database at localhost:27017 mongo 192.169.0.5/foo start the shell using the foo database at 192.169.0.5:27017 mongo 192.169.0.5:9999/foo start the shell using the foo database at 192.169.0.5:9999 mongo script1.js script2.js script3.js run three scripts and exit OPTIONS
--shell run the shell after executing files --help show usage information --host HOST server to connect to (default HOST=localhost) --port PORT port to connect to (default PORT=27017) --nodb do not connect to mongod --eval SCRIPT evaluate JavaScript -u USERNAME specify user to log in as -pPASSWORD specify password of user (notice there is no space) COPYRIGHT
Copyright 2007-2009 10gen SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org. AUTHOR
Kristina Chodorow 10gen June 2009 MONGO(1)
All times are GMT -4. The time now is 03:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy