Sponsored Content
Top Forums Shell Programming and Scripting How to pass value from unix shell to sql session? Post 302459308 by clx on Monday 4th of October 2010 10:28:45 AM
Old 10-04-2010
how do you connect to database? generally with here documents, you can use variable like usual ($var )

Code:
var=col1
sqlplus -s $user/$pass@$sid << SQL >> session.log
select $var from table where......
quit
SQL

 

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

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

To pass the .sql file as a paramter to sqlplus through shell programming

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)
Discussion started by: Hemamalini
9 Replies

3. Shell Programming and Scripting

How to pass pl/sql table values to shell script

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)
Discussion started by: rosalinda
1 Replies

4. Shell Programming and Scripting

Need to return fail or pass from shell script on the basis of pl/sql code execution

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)
Discussion started by: alok1301
2 Replies

5. Shell Programming and Scripting

How to pass arguments to SQL file passed in shell script?

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)
Discussion started by: dazdseg
3 Replies

6. Shell Programming and Scripting

How to Pass the Output Values from the PL/SQL Procedure to Shell Script?

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)
Discussion started by: funonnet
5 Replies

7. Programming

pass value from Oracle sql to Korn shell

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)
Discussion started by: megha2525
14 Replies

8. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

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

9. Shell Programming and Scripting

Need Help: Shell script to call sql session with variables stored in .txt file

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)
Discussion started by: Khan28
4 Replies

10. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

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
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)
All times are GMT -4. The time now is 09:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy