Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Execute multiple SQL scripts from single SQL Plus connection
Top Forums Shell Programming and Scripting Execute multiple SQL scripts from single SQL Plus connection Post 302464085 by tene on Tuesday 19th of October 2010 08:45:33 AM
Old 10-19-2010
Why don't you do this?
Code:
echo "select STATUS from v$instance;
select VERSION from v$instance;
select VERSION from v$instance;
" > $SQL_FILE

sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT

 

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

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

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... (3 Replies)
Discussion started by: Leion
3 Replies

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

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

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

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

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... (3 Replies)
Discussion started by: huasheng8
3 Replies

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

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

LEARN ABOUT X11R4

asadmin-restart-instance

asadmin-restart-instance(1AS)					   User Commands				     asadmin-restart-instance(1AS)

NAME

       asadmin-restart-instance, restart-instance - restarts the specified server instance and all the services associated with it

SYNOPSIS

       restart-instance  [--user  admin_user]  [--password admin_password] [--host localhost] [--port 4848] [--local=false] [--domain domain_name]
       [--passwordfile filename] [--secure|-s]instance_name

       Use the restart-instance to restart the instance with the instance name specified. The restart-instance command can be run both locally and
       remotely.  To restart remotely, the administration server must be running on the hostname and port number specified. The user authenticates
       using the password identified for the administration server. Additionally, the instance must already exist within the domain served by  the
       administration server, and the instance must be running.  The restart-instance command is not supported on Windows.

OPTIONS

       --user		       administrative user associated for the instance.

       --password	       administrative password corresponding to the administrative user.

       --host		       host name of the machine hosting the administrative instance.

       --port		       administrative port number associated with the administrative host.

       --local		       determines if the command should delegate the request to administrative instance or run locally.

       --domain 	       name of the domain.

       --passwordfile	       file containing passwords appropriate for the command (e.g., administrative instance).

       --secure 	       if true, uses SSL/TLS to communicate with the administrative instance.

OPERANDS

       instance_name	       name of the instance to be restarted.

       Example 1: Using restart-instance in local mode

       asadmin> restart-instance --local --domain domain1 server1
       Instance server1 started

       Where: server1 is the name of the instance restarted on the domain1 domain.

       Example 2: Using restart-instance in remote mode

       asadmin> restart-instance --user admin --password adminadmin --host bluestar --port 4848 server1
       Instance server1 started

       Where:  server1	is the name of the instance restarted. The restarted instance is associated with the user, password, host, and port number
       specified.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

INTERFACE EQUIVALENT

       Server Instance page

       asadmin-delete-instance(1AS),   asadmin-start-instance(1AS),   asadmin-create-instance(1AS),   asadmin-stop-instance(1AS),   asadmin-start-
       appserv(1AS), asadmin-stop-appserv(1AS), asadmin-start-domain(1AS), asadmin-stop-domain(1AS)

J2EE 1.4 SDK							    March 2004					     asadmin-restart-instance(1AS)
All times are GMT -4. The time now is 07:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy