|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
using SQL from Shell
Post 302297484 by vbe on Friday 13th of March 2009 02:44:36 PM
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey I have this shell script that I am trying to run and receive a value from a sql query.Then later use the value in an if stmt... I cannot get this to work for nothing..
Here is the script
(sqlplus -s $usrname/$passwrd <<!
set head off feed off pagesize 0
select b
from table;
set head... (9 Replies)
Discussion started by: devaris22
9 Replies
2. Shell Programming and Scripting
can anyone tel me the logic behind the foll kind of blocks....the ones we use when v embed sql queries qithin shell script...
for example...
<path> sqlplus << A
.............................
.............................
SQL statements
................................ (2 Replies)
Discussion started by: tej.buch
2 Replies
3. Shell Programming and Scripting
Hi all,
I am running an sql file from unix .In the log file along with the output
i am getting details of connecting and disconnecting sqlplus like
It saves the output with "Connected to Oracle8i Enterprise Edition Release
8.1.7.4.0 Connected as apps" and "disconnected... (1 Reply)
Discussion started by: rrs
1 Replies
4. Shell Programming and Scripting
Guys,Please look at a simple shell which validates presence of a customer table in OASIS schema. SQL Query for validation is wrong(Table name in quotes should not have schema name OASIS.). And shell is working correctly (with exit 1) as it will never get count=1 with this query.
But it is... (2 Replies)
Discussion started by: bhush782003
2 Replies
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
7. Shell Programming and Scripting
sqlplus -s <<__END__
${USER}/${PASS}@${DB}
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK
WHENEVER OSERROR EXIT FAILURE ROLLBACK
SET ECHO ON
SET TIMING ON
SET SERVEROUTPUT ON SIZE 1000000
select count(*) from table where start LIKE '10-JUN-10';
EXIT
__END__
result=$?
echo $resultThis gives... (9 Replies)
Discussion started by: sandy1028
9 Replies
8. UNIX for Advanced & Expert Users
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. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I need to excute two .sql scripts sequentially within file.sh
sqlplus user/pass@db1 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy1.sql
THEN
sqlplus user/pass@db2 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy3.sql
Thanks,
Soph (4 Replies)
Discussion started by: soph1997
4 Replies
LEARN ABOUT SUSE
kitpost
KITSEND(1) General Commands Manual KITSEND(1) NAME
kitpost - posts distribution kits SYNOPSIS
kitpost [ -hrV ] [ -H file ] [ -D desc ] [ -m dest1,dest2 ] [ kits ] [ newsgroups ] DESCRIPTION
Kitpost posts distribution kits made by makedist to some (source) newsgroups specified on the command line. If you do not specify any kit list, then all the kits are sent. Otherwise, only the specified kits will be (re)sent. A kit list may include ranges, 1-10 specifying kits 1 through 10, and 5- meaning kits 5 up to the last one. You may also specify kit num- bers by separating them with commas or spaces, and even mix with ranges, such as: 1 3 5-7 9. Kitpost ensures correct References: lines are inserted in your postings so that all parts but the first point to the root article. Threaded newsreaders and end-users traditionally appreciate that. OPTIONS
The following options are recognized by kitpost: -h Print help message and exit. -m dest1,destn Sends kits by e-mail to the specified recipients. This option may be used in conjunction with newsgroup posting. It is mainly intended for sites where direct posting to a moderated newsgroup is not allowed by inews. You may thus send your kits to the newsgroup moderator in a form that will ease the whole posting process. -r Signals a repost. -D description Specify a description string that will be added to the subject line. Usually a brief sentence (less than, say, 40 characters). -H file Specify a file to be used as header introduction in the first part of your posting. Usually the root README file. -V Print version number and exit. BUGS
Article cross-referencing is properly set-up only when the whole package is (re)posted in one batch. It is not currently possible to set-up the article headers manually or better, interactively. AUTHOR
Raphael Manfredi <ram@hptnos02.grenoble.hp.com> SEE ALSO
makedist(1), kitsend(1). ram KITSEND(1)