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
DROP 
DATABASE(7) SQL Commands DROP DATABASE(7) NAME
DROP DATABASE - remove a database SYNOPSIS
DROP DATABASE [ IF EXISTS ] name DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to postgres or any other database to issue this command.) DROP DATABASE cannot be undone. Use it with care! PARAMETERS
IF EXISTS Do not throw an error if the database does not exist. A notice is issued in this case. name The name of the database to remove. NOTES
DROP DATABASE cannot be executed inside a transaction block. This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb [dropdb(1)] instead, which is a wrapper around this command. COMPATIBILITY
There is no DROP DATABASE statement in the SQL standard. SEE ALSO
CREATE DATABASE [create_database(7)] SQL - Language Statements 2010-05-14 DROP DATABASE(7)
All times are GMT -4. The time now is 03:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy