01-29-2008
Did you find the answer to your question.
Passing a parameter to unix script from sqlplus
thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
Hi there
I'm new to UNIX scripting; I’m stuck with the following
I have an Oracle SQL script that takes three parameters
1- File Name
2- File Path
3- File creation date
Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need... (3 Replies)
Discussion started by: windjashi
3 Replies
5. Shell Programming and Scripting
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Discussion started by: Shri123
6 Replies
6. UNIX for Dummies Questions & Answers
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
Discussion started by: boopathyvasagam
2 Replies
7. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
8. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
9. Shell Programming and Scripting
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies
10. Shell Programming and Scripting
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies
LEARN ABOUT DEBIAN
purity-ng
PURITY-NG(6) Games Manual PURITY-NG(6)
NAME
purity-ng - general purpose purity testing software
SYNOPSIS
purity-ng [OPTION]... list|FILE|TESTNAME
DESCRIPTION
Purity is an interactive purity test program with a simple, user interface and datafile format. For each test, questions are printed to
the your terminal, and you are prompted for an answer to the current question. At a prompt, these are your choices:
y Answer "yes" to the question.
n Answer "no" to the question.
b Backup one question, if you answered it incorrectly, or someone is watching you take the test, and you don't (or do) want to admit a different answer.
s Print your current score on the test you are taking.
q Quit the test, and print the current score.
? Print a help screen for the current prompt.
At the end of the test, your score is printed out. For most purity tests, lower scores denote more "experience" of the test material.
OPTIONS
--version
print current version of purity-ng
-h, --help
show the help message and exit
-p print the test without prompting for answers.
-r decrypt the test using the Rot 13 algorithm.
To get a list of all purity tests available globally on your system, run purity-ng list.
AUTHORS
purity was originally written by Eric Lechner in 1989. purity-ng is a reimplementation of purity in Python for modern systems, written by
Simon Fondrie-Teitler and Luke Faraone.
This manual page was written by Luke Faraone.
BUGS
If you find bugs in the application, please report these to <https://bugs.launchpad.net/purity-ng> or to your distribution's distributor.
SEE ALSO
purity(6)
Running purity-ng format provides documentation about the datafile format.
Additional documentation is available online at <http://packages.python.org/purity-ng>.
January 7, 2011 PURITY-NG(6)