Execute multiple SQL scripts from single SQL Plus connection Post: 302466086

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

2. UNIX for Dummies Questions & Answers

split a single sql file into multiple files

Hi,I have a single sql file containing many create table ddl's.Example: CREATE TABLE sec_afs ( rpt_per_typ_c char(1) NOT NULL, rpt_per_typ_t varchar(20) NULL, LOCK ALLPAGES go EXEC sp_primarykey 'sec_afs', rpt_per_typ_c go GRANT SELECT ON sec_afs TO developer_read_only...

3. Programming

Single sql query to spool to multiple files

Is there anyway to spool my select statement into spool files of max 10000 records each? eg I have a select statement that will return 45000 records. A normal spool command will output the 45000 into just one spool file. How can I make sqlplus do this? 00001 - 10000 records --- spool...

4. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

5. Shell Programming and Scripting

How to execute the multiple line sql using shell script

Hi All, Please help me to write a shell script to execute the below sql query. select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery, (select j.bill_no from billinfo_T y, bill_t j where...

6. Shell Programming and Scripting

Not able to execute many SQL scripts within a shell script

I am using HP-UX: I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is - sqlplus user/temp1234 <<! set serverout on set feedback off set pages 1000 set colsep , set echo off spool /home/supp1/pks/output.csv...

7. Shell Programming and Scripting

SQL query in a loop with single sqlplus connection

Hi, I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data. Is it possible to have a single sqlplus connection before entering the loop and...

8. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

9. UNIX and Linux Applications

how to execute multiple .sql scripts from within a shell script using sqlplus

using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks any help would be appreciated :wall:

10. UNIX for Beginners Questions & Answers

How to use for loop to execute multiple .sql files while using SQLPLUS for db connection.?

Hello , Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this.. How i can use for loop to invoke my...

LEARN ABOUT DEBIAN

svn-bisect

SVN-BISECT(1)						      General Commands Manual						     SVN-BISECT(1)

NAME

       svn-bisect - Bisect Subversion revisions to find a regression

SYNOPSIS

       svn-bisect start [good_rev [bad_rev]]

       svn-bisect {good|bad} [rev]

       svn-bisect run command

       svn-bisect reset

       svn-bisect status

DESCRIPTION

       svn-bisect  helps  to  automate	finding a bug or behavior change in a Subversion working copy.	Given an initial "good" revision, with the
       desired or original behavior, and a newer "bad" revision, with the undesired or modified behavior,  svn-bisect  will  do  a  binary  search
       through the revision range to find which revision caused the change.

       svn-bisect  must  be initialized in a working copy, with svn-bisect start.  It also needs to be given at least one good revision (the base-
       line) and one bad revision (known modified behavior) revision.

       Sub-commands:

       start  Initializes or reinitializes svn-bisect; optionally takes good and bad revision parameters.

       good rev

       bad rev
	      Tells svn-bisect that a revision is good or bad, defining or narrowing the search space.	If not specified, revision defaults to the
	      current  revision  in  the working copy.	svn-bisect will then update to a revision halfway between the new good and bad boundaries.
	      If this update crosses a point where a branch was created, it switches in or out of the branch.

       reset  Resets the working copy to the revision and branch where svn-bisect start was run.  In the simple case this is equivalent to  rm	-r
	      .svn-bisect;  svn  update,  but  not  if	it  has crossed branches, and not if you did not start at the HEAD revision.  In any case,
	      svn-bisect never keeps track of mixed-revision working copies, so do not use svn-bisect in a working  copy  that	will  need  to	be
	      restored to mixed revisions.

       status Prints a brief status message.

       run command
	      Runs  the  bisection in a loop.  You must have already defined initial good and bad boundary conditions.	Each iteration through the
	      loop runs command as a shell command (a single argument, quoted if necessary) on the chosen revision, then  marks  the  revision	as
	      good or bad, based on the exit status of command.

EXAMPLES

       Assume you are trying to find which revision between 1250 and 1400 caused the make check command to fail.

	   svn-bisect start 1250 1400
	   svn-bisect run 'make check'
	   svn-bisect reset

ENVIRONMENT

       SVN    The Subversion command-line program to call (default svn).

FILES

       .svn-bisect
	      The directory containing state information, removed after a successful bisection.

SEE ALSO

       git-bisect(1).

AUTHOR

       Written by Robert Millan and Peter Samuelson, for the Debian Project (but may be used by others).

								    2009-10-22							     SVN-BISECT(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini

2. UNIX for Dummies Questions & Answers

split a single sql file into multiple files

Discussion started by: smarter_aries

3. Programming

Single sql query to spool to multiple files

Discussion started by: Leion

4. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Discussion started by: reptile