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

Thread Tools Search this Thread
Operating Systems Linux How to execute a simple select script using a shell script?
# 1  
Old 10-17-2013
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

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.


Last edited by Don Cragun; 10-17-2013 at 02:55 AM.. Reason: Add CODE tags.
# 2  
Old 10-17-2013
Normally, it would go something like this:
sqlplus -s / as sysdba << !
set pagesize off heading off feedback off
<your select statements go here>

To run the "script":
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:
ORACLE_SID=<your Oracle SID here>
. oraenv

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

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

3. Shell Programming and Scripting

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

I have a master shell script which will invoke 2 shell scripts (, Both of these shell scripts will execute stored procedure. I will invoke, respectively. Now both of these scripts are executing parallel. But i want to invoke the 2nd script( (3 Replies)
Discussion started by: vel4ever
3 Replies

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 (2 Replies)
Discussion started by: Shri123
2 Replies

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 (7 Replies)
Discussion started by: Sooraj_Linux
7 Replies

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 Replies)
Discussion started by: jayachandran87
7 Replies

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 on the host02 like following : host01> ssh host02 include nohup command like follwing : nohup /home/jack/ & after i execute ssh host02 one the host01. i can't found (1 Reply)
Discussion started by: orablue
1 Replies

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

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

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 (1 Reply)
Discussion started by: lakshmis10
1 Replies
Login or Register to Ask a Question