|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
need some help in executing sql
Post 302199196 by sais on Monday 26th of May 2008 04:45:42 AM
05-26-2008
need some help in executing sql
i am stuck with a problem ...
i have a shell script that gets the file name as input and performs the following operation...
it runs through a for loop inside from which i connect to sqlplus and run a procedure that creates a number of tables ..
there is no space in my server so we have made them as temporary tables ..
problem is ..... since they are temporary tables when the session expires the data in them vanishes .... but i do not want the data to vanish ...
problem in that is that without exiting from the sql server i cannot get the value of the next filename ...
....
sample code :
for filename in `ls *.in`
do
log "$filename: loading"
echo "Begin" >in.sql
echo "execute immediate 'truncate table input_data1';" >>in.sql
echo "end;" >>in.sql
echo "/" >>in.sql
echo `sqlplus -s ${ORACLE_USERNAME}/${ORACLE_PASSWORD} <in.sql`
echo `exit`
echo "Begin" >in.sql
echo "loading_gtt;" >>in.sql
echo "end;" >>in.sql
echo "/" >>in.sql
echo `sqlplus -s ${ORACLE_USERNAME}/${ORACLE_PASSWORD} <in.sql`
echo `exit`
the procdure in bold is what is going to create all the temporay tables ... the value of which expire when i close the session....
pls help ...
i have a shell script that gets the file name as input and performs the following operation...
it runs through a for loop inside from which i connect to sqlplus and run a procedure that creates a number of tables ..
there is no space in my server so we have made them as temporary tables ..
problem is ..... since they are temporary tables when the session expires the data in them vanishes .... but i do not want the data to vanish ...
problem in that is that without exiting from the sql server i cannot get the value of the next filename ...
....sample code :
for filename in `ls *.in`
do
log "$filename: loading"
echo "Begin" >in.sql
echo "execute immediate 'truncate table input_data1';" >>in.sql
echo "end;" >>in.sql
echo "/" >>in.sql
echo `sqlplus -s ${ORACLE_USERNAME}/${ORACLE_PASSWORD} <in.sql`
echo `exit`
echo "Begin" >in.sql
echo "loading_gtt;" >>in.sql
echo "end;" >>in.sql
echo "/" >>in.sql
echo `sqlplus -s ${ORACLE_USERNAME}/${ORACLE_PASSWORD} <in.sql`
echo `exit`
the procdure in bold is what is going to create all the temporay tables ... the value of which expire when i close the session....
pls help ...
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
If I execute this script:
$ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log
$DB_id/$DB_pswd@$DB_server
start test.sql
EOF
the sql script executes with no errors.
IF I execute the following script:... (12 Replies)
Discussion started by: mh53j_fe
12 Replies
2. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
3. Programming
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Discussion started by: maverick1234
1 Replies
4. UNIX for Advanced & Expert Users
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Discussion started by: maverick1234
1 Replies
5. Shell Programming and Scripting
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Discussion started by: maverick1234
1 Replies
6. UNIX for Advanced & Expert Users
I have few .sql file at some location say /x/y/z. I want to execute those .sql files in UNIX server so that all packages,procedures can be applied on the database of the UNIX server. (1 Reply)
Discussion started by: Dip
1 Replies
7. Shell Programming and Scripting
Hi,
How to execute sql statements from the .sh file ??
Means, when we run .sh file then the sql statements within it should be get executed one by one from the sqlplus
With Regards (3 Replies)
Discussion started by: milink
3 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have one SQL file prepared in UNIX and one script that is executing that.
In SQL i have Update and create queries.
I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback.
I just have 1 create... (2 Replies)
Discussion started by: abhii
2 Replies
9. UNIX for Beginners Questions & Answers
Hello~
I have a requirement to write a shell script which will connect to the oracle database and run a select count(*) query on a table.
The script should succeed only when the count returns a number greater than zero. If the count returns zero, the script should fail.
Can someone please... (3 Replies)
Discussion started by: Naren.N
3 Replies
10. UNIX for Beginners Questions & Answers
Hi Folks,
I have requirement to pull a bunch of SQL's from a table in DB and execute them in parallel and update the status of each query as and when they complete. Can you please help me with ideas on how this can be achieved?
create table list_of_sql
(
id number,
full_sql... (3 Replies)
Discussion started by: member2014
3 Replies
LEARN ABOUT MOJAVE
vtysh
VTYSH(1) Version 0.96.5 VTYSH(1) NAME
vtysh - a integrated shell for Quagga routing software SYNOPSIS
vtysh [ -b ] vtysh [ -E ] [ -d daemon ] ] [ -c command ] DESCRIPTION
vtysh is a integrated shell for Quagga routing engine. OPTIONS
Options available for the vtysh command: -b, --boot Execute boot startup configuration. It makes sense only if integrated config file is in use (not default in Quagga). See Info file Quagga for more info. -c, --command command Specify command to be executed under batch mode. It behaves like -c option in any other shell - command is executed and vtysh exits. It's useful for gathering info from Quagga routing software or reconfiguring daemons from inside shell scripts, etc. Note that mul- tiple commands may be executed by using more than one -c option and/or embedding linefeed characters inside the command string. -d, --daemon daemon_name Specify which daemon to connect to. By default, vtysh attempts to connect to all Quagga daemons running on the system. With this flag, one can specify a single daemon to connect to instead. For example, specifying '-d ospfd' will connect only to ospfd. This can be particularly useful inside scripts with -c where the command is targeted for a single daemon. -e, --execute command Alias for -c. It's here only for compatibility with Zebra routing software and older Quagga versions. This will be removed in future. -E, --echo When the -c option is being used, this flag will cause the standard vtysh prompt and command to be echoed prior to displaying the results. This is particularly useful to separate the results when executing multiple commands. -h, --help Display a usage message on standard output and exit. ENVIRONMENT VARIABLES
VTYSH_PAGER This should be the name of the pager to use. Default is more. FILES
/usr/local/etc/vtysh.conf The default location of the vtysh config file. /usr/local/etc/Quagga.conf The default location of the integrated Quagga routing engine config file if integrated config file is in use (not default). WARNING
This man page is intended to be a quick reference for command line options. The definitive document is the Info file Quagga. SEE ALSO
bgpd(8), ripd(8), ripngd(8), ospfd(8), ospf6d(8), isisd(8), zebra(8) BUGS
vtysh eats bugs for breakfast. If you have food for the maintainers try http://bugzilla.quagga.net AUTHORS
See http://www.zebra.org and http://www.quagga.net or the Info file for an accurate list of authors. Quagga VTY shell 27 July 2006 VTYSH(1)