|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
How to use parameter in sql script pass from unix script?
Post 302511485 by apskaushik on Thursday 7th of April 2011 01:02:23 AM
04-07-2011
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
2. Shell Programming and Scripting
Dear Friends,
Please help me to achieve the following:
I want to pass one parameter from Shell-script to Sql-script.
Example:
My ShellScript.sh is calling report.sql like this:
/bin/sqlplus /reports.sql
And
My report.sql is calling many Stored-Procedures like this:
exec... (0 Replies)
Discussion started by: subodhbansal
0 Replies
3. Shell Programming and Scripting
Hi,
I need to pass 4 parameters from Oracle Procedure to Unix Shell script..
procedure signature :-
UNIX Shell script:
Problem: 1. Suppose pdffile and pdfresult has Null values in Oracle procedures but unix shell will read parameters by spaces so
I am getting wrong parameters... (7 Replies)
Discussion started by: sandy162
7 Replies
4. UNIX for Advanced & Expert Users
Hi,
I am writing a wrapper script(wrap_script.sh) to one of the main scripts (main_script.sh)
The main script is executed as following:
./main_script.sh <LIST> <STARTDATE> <ENDDATE>
looks for a parameter which is a LIST(consists of different list names that need to be processed), START/END... (0 Replies)
Discussion started by: stunnerz_84
0 Replies
5. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
6. Post Here to Contact Site Administrators and Moderators
Variable I have in my shell script
diff=$1$2.diff
id=$2
new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new
I could see value of $id is not passing to the awk... (0 Replies)
Discussion started by: Ashunayak
0 Replies
7. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
8. Shell Programming and Scripting
Hi,
I have an XML file like the following...
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ONDEMAND_JOB VERSION="5.1" LOCALE="en_US">
<IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (2 Replies)
Discussion started by: Debalina Roy
2 Replies
9. Shell Programming and Scripting
Hi,
I have an XML file like the following...
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ONDEMAND_JOB VERSION="5.1" LOCALE="en_US">
<IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (3 Replies)
Discussion started by: Debalina Roy
3 Replies
10. Shell Programming and Scripting
I have written a script which will take input parameter as another script.
However, if the script passed as input parameter has parameters then this script doesn't work.
I have a script b.ksh which has 1 and 2 as parameters
I have a script c.ksh which has 3,4 and 5 as parameters
vi a.ksh... (1 Reply)
Discussion started by: Vee
1 Replies
LEARN ABOUT DEBIAN
maria-vis
MARIA-VIS(1) General Commands Manual MARIA-VIS(1) NAME
maria-vis - graph visualization script for maria SYNOPSIS
maria-vis DESCRIPTION
This manual page documents briefly the maria-vis command. maria-vis is a lefty script invoked by maria in order to visually present information to the user. The script reads commands and direc- tives from standard input and may write maria query language commands to standard output. An end-of-file condition on standard input ter- minates the script. The script is built on top of the dotty script that is part of the GraphViz package. The commands prefixed with visual in maria issue two kinds of commands to this script: new(); or add(); followed by a newline character and a graph definition in the dot input language. The new function in the script displays the graph in a new window, while the add function copies information from the graph to the last modi- fied graph. SEE ALSO
dot(1), dotty(1), lefty(1), maria(1). AUTHOR
This manual page was written by Marko Makela <msmakela@tcs.hut.fi>. The maria-vis script and the visualization option were designed and implemented by Marko Makela. Please see the copyright file in /usr/share/doc/maria for details. August 10, 2001 MARIA-VIS(1)