How to execute a simple select script using a shell script?

Login or Register to Ask a Question and Join Our Community

How to execute a simple select script using a shell script?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Operating Systems Linux How to execute a simple select script using a shell script?

10-17-2013

Registered User

1, 0

Join Date: Oct 2013

Last Activity: 17 October 2013, 2:07 AM EDT

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to execute a simple select script using a shell script?

Hi team,

I have two select statements and need to run them using SYSDBA user

Code:

select * from temp_temp_seg_usage;

select segment_name, tablespace_name, bytes/ (1024*1024) UsedMb from 
dba_segments where segment_name='TEMP_TEMP_SEG_USAGE';

Need to run this using a shell script say named select.txt

Can some one help me with the code, i am really new to shell scripting.

Regards,
Pramod

Last edited by Don Cragun; 10-17-2013 at 02:55 AM.. Reason: Add CODE tags.

pamsy78

View Public Profile for pamsy78

Find all posts by pamsy78

10-17-2013

Administrator Emeritus

9,179, 1,331

Join Date: Jun 2009

Last Activity: 26 February 2019, 5:57 PM EST

Posts: 9,179

Thanks Given: 430

Thanked 1,331 Times in 1,120 Posts

Normally, it would go something like this:

Code:

sqlplus -s / as sysdba << !
set pagesize off heading off feedback off
<your select statements go here>
!

To run the "script":

Code:

sqlplus -s / as sysdba @select.txt

Make sure "select.txt" exits the script.

If you need to set your Oracle environment beforehand, run this before the sqlplus:

Code:

ORAENV_ASK=NO
ORACLE_SID=<your Oracle SID here>
. oraenv

Scott

View Public Profile for Scott

Find all posts by Scott

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Batch script to execute shell script in UNIX server

Hi team, My requirement is to transfer pdf files from windows machine to unix server and then from that unix server we should sftp to another server. I have completed the first part i.e From windows to using to unix server with the help of psftp.exe code: psftp user@host -pw password <...

2. Shell Programming and Scripting

Execute shell script even if the first script fails

All, I executing a perl script and shell script from a master shell script. i will execute the perl script first and have to execute the shell script after the completion of perl execution. Below is the code i use for it, script_root='/dev/scripts' /usr/bin/perl -S $script_root/test.pl;...

3. Shell Programming and Scripting

How to execute one shell script after execution of another shell script?

I have a master shell script master.sh which will invoke 2 shell scripts (test1.sh,test2.sh). Both of these shell scripts will execute stored procedure. I will invoke test1.sh, test2.sh respectively. Now both of these scripts are executing parallel. But i want to invoke the 2nd script(test2.sh)...

4. Shell Programming and Scripting

Dos batch script to execute unix shell script

Can anyone help me with a dos batch script to execute a shell script residing in an unix server. I am not able to use ssh. Thanks in advance

5. Shell Programming and Scripting

how to execute ksh simple shell script without creating .sh file

please help me to execute a simple shell script like for i in `ls echo $i done . i dont want to create a new sh file to execute it. Can i just type and execute it ? because I always this kind of simple for loops . Please help . Thanks

6. Shell Programming and Scripting

Cannot execute Unix command in a simple perl script

Am trying to lean perl scripting in Unix OS to automate my tasks. Please find the below perl script i have tried #!/usr/bin/perl -w print "Please Enter the VG name to be checked:"; $A = <>; print "Please Enter the free size to be checked in GB:"; $B = <>; $vgcheck = `vgdisplay...

7. Shell Programming and Scripting

How to use ssh execute other shell script on other host (shell script include nohup)?

i want use ssh on the host01 to execute autoexec.sh on the host02 like following : host01> ssh host02 autoexec.sh autoexec.sh include nohup command like follwing : nohup /home/jack/deletedata.sh & after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh...

8. Shell Programming and Scripting

Execute unix shell script to text file using the script

Hi all, I am beginner in UNIX...I want to use unix shell script to create text.file...I know how to use using by command...can anybody tell me for the script? Thanks i changed the threads title from "tex file" to "text file", because "tex" would probably be misunderstood as reference to...

9. UNIX for Dummies Questions & Answers

To call/execute a shell script from a shell script

Hi , I have 4 shell scripts a.ksh b.ksh -> depends on a.ksh success -> log into b.log c.ksh -> depends on b.ksh success -> log into c.log d.ksh -> depends on c.ksh success -> log into d.log I will have to write main.ksh ( execute a.ksh , log into a.log if a.ksh= success, execute...

10. Shell Programming and Scripting

how to execute a batch script from shell script

Hi, I am new to shell scripting. Can anyone tell how to invoke a batch program from my shell script thnx

Login or Register to Ask a Question