Hi,
Currently i have a .sql file 1.sql.
I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script.
How I should I do.can anyone help me pls.
I have an req where I need to send the .sql file and the place where the script has to create a .csv... (9 Replies)
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Hi guys,
I am quite new in shell scripting.
I am tring to promote some oracle jobs into control-M. In control-M, I am calling a script which establishes a connection with database and execute some procedures. Now I want if that PL/sql Block got failed script should return failure to... (2 Replies)
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am doing .
VALUE=`sqlplus -silent username/password << END
set pagesize 0 feedback off verify off... (14 Replies)
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)
Hi,
I need help in writing a shell script which can read data from a text file (Cancel_ID.txt) and then calls sqlplus session (Cancel.sql) with the first line parameter of the text file ("0322600453") till all rows are not completed.
... (4 Replies)
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
LEARN ABOUT DEBIAN
sb2-session
sb2-session(1) sb2-session man page sb2-session(1)NAME
sb2-session - manage scratchbox2 sessions
SYNOPSIS
sb2-session [COMMAND [PARAMS]]
DESCRIPTION
sb2-session is used to create attachable scratchbox2 sessions. You can save session even when you haven't done '-S session' during sb2
startup.
Note that you can give parameters to attach command which are passed verbatim to sb2. If there is only one session to attach, it is
selected automatically.
If no command is given, help text is printed.
COMMANDS
help shows help text
save saves current session
list lists detached sb2 sessions
delete SESSION
deletes given session
attach [SESSION [PARAMS]]
attaches to a given session
setenv VARIABLE VALUE
store a value for an environment variable
showenv
show stored environment variables
EXAMPLES
Basic usage is:
[SB2 .. ] $ sb2-session save # save session
[SB2 .. ] $ ^D # exit
Later we can then attach to this session:
% sb2-session attach
If there are more than one saved session, then:
% sb2-session list
session.XXXX TARGET_ARM My Comment
session.YYYY TARGET_ARM My Comment 2
session.ZZZZ TARGET_MIPS
% sb2-session attach session.YYYY
Here we pass '-eR' to sb2 and we only have one saved session:
% sb2-session attach -- -eR
'--' marks end of parameter list for sb2-session.
setenv VARIABLE VALUE can be used to add environment variables, that will become active when a saved session is later taken into use
(either by sb2-session attach or by sb2 -J).
setenv VARIABLE VALUE does not change environment of sessions that are already active.
showenv lists environment variable settings which have been stored with this tool. It does not show environment variables from other
sources.
SEE ALSO sb2(1)AUTHOR
Mika Westerberg
2.2 21 December 2010 sb2-session(1)