Passing Shell array to SQLPlus Post: 302584741

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

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. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Hi, I want to input unix variable to sqlplus.The following is working fine sqlplus username/password @dummy.sql param1 param2 << EOF create user $1 identified by $2; EOF But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that?? Thanks...

3. Shell Programming and Scripting

error in passing a variable to sqlplus from a shell script

hi, I am using a shell script from where i will be conecting to sqlplus.. i am having a problem in passing a variable to sqlplus query.. i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am...

4. Shell Programming and Scripting

Passing the unix variable to sqlplus

Hi, I am writing a script which creates an external table using a shell script. My requirement is like this. Usage: . ./r.ksh <table_name> - this should create an external table. e.g . ./r.ksh abc - this should create an external table as abc_external. How do i achieve this? Please...

5. Shell Programming and Scripting

Passing a file handler and an array from Perl to Shell Script

Hi there, I am trying to call a shell script from a Perl script. here is the code: @args = ("sh", "someshellprg.sh", "a file handler", "an array"); system(@args) == 0 or die "system @args failed: $?"; in the shell program, I examine if the arguments exits using: if then echo...

6. Shell Programming and Scripting

Shell Script passing parameters to sqlplus code

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

7. Shell Programming and Scripting

Passing a parameter from a shell script to sqlplus

Hi All, I'm new to Linux and scripting, apologies in advance for 'stupid' questions. Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work. here is my code. #!/bin/sh TERM=vt100 export TERM...

8. Shell Programming and Scripting

Passing sqlplus output to shell variable

Hi , I am using below code : for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'` do ORACLE_SID=$i export ORACLE_SID; dest=`sqlplus "/ as sysdba" <<EOF set heading off feedback on verify off select DESTINATION from v\\$archive_dest where target in...

9. Shell Programming and Scripting

Passing Oracle function as file input to sqlplus

Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts. Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file in a unix location. I want...

10. Shell Programming and Scripting

Passing string from bash to sqlplus

Hello, I have file (PARFILE) with string on first line: INCLUDE=SCHEMA:"IN$ 'SCHEMA1','SCHEMA2','SCHEMA3' $"In .sh script I use: .... IMPORT_SCHEMA=`awk 'NR==1{print $2}' ${PARFILE}` ...print $2 is because 'SCHEMA1','SCHEMA2','SCHEMA3' is 2nd column in file echo "$IMPORT_SCHEMA"...

LEARN ABOUT SUSE

osd_cat

XOSD(1xosd)															       XOSD(1xosd)

NAME

       osd_cat - X on-screen file displayer

SYNOPSIS

       osd_cat [OPTION] [FILE]...
       osd_cat -b percentage|slider [OPTION]

DESCRIPTION

       Display FILE, or standard input, on X screen.

       -p, --pos=POS
	      This option tells osd_cat where to display the text. POS can be top, middle, or bottom. The default is top.

       -o, --offset=OFFSET
	      This option specifies the offset from the top or bottom of screen the text is displayed. The default is 0.

       -A, --align=ALIGN
	      This option tells osd_cat where to display the text. ALIGN can be left, right or center. The default is left.

       -i, --indent=OFFSET
	      This option specifies the INDENT from the left of screen the text is displayed. The default is 0.

       -f, --font=FONT
	      This option specifies the FONT to be used for displaying the text. The default is fixed.

       -c, --color=COLOR
	      This option specifies the COLOR to be used for displaying the text. The default is red.

       -d, --delay=TIME
	      This option specifies the number of seconds the text is displayed. The default is 5 seconds.

       -l, --lines=LINES
	      This option specifies the number of LINES to scroll the display over. The default is 5.

       -s, --shadow=OFFSET
	      This option specifies the OFFSET of the text shadow. The default is 0, which means no text shadow is created.

       -a, --age[=SCROLL_AGE]
	      This  option  affects  screen  redrawing.  If SCROLL_AGE seconds pass before a new line is ready (for example, you're reading from a
	      pipe), all lines are cleared at once instead of being scrolled off as new lines replace old lines. The default is 0.
	      When no SCROLL_AGE is explicitly given, the current value from DELAY is used.

       -w, --wait
	      This option also affects screen redrawing. When there is data ready to be put on screen, this option  will  cause  osd_cat  to  wait
	      until the display is clear. An alternative to scrolling.

       -b, --barmode=TYPE
	      Lets  you  display a percentage or slider bar instead of just text.  TYPE may be percentage or slider.  In this mode no text is read
	      from any file, but the following options can be used:

       -P, --percentage=PERCENTAGE
	      This option specified the position of the percentage / slider bar.  PERCENTAGE may be in the range from 0 to 100, the default is 50.

       -T, --text=TEXT
	      This option specifies an optional TEXT which gets displayed above the percentage bar.  The default is empty, so no  additional  text
	      is displayed.

       -h, --help
	      display help (which is often more up to date) and exit

       With no FILE, or when FILE is -, read standard input.

AUTHOR

       Martijn	van  de  Streek  <martijn@foodfight.org>,  Some  patching  done  by  Malcolm  Valentine  <farkit@iprimus.com.au>  and  Tim  Wright
       <tim@ignavus.net>.
       xosd was written by Andre Renaud <andre@ignavus.net> and is maintained by Tim Wright <tim@ignavus.net>

SEE ALSO

       More   information   on	 the   X   OSD	 Library   and	 its	author	  can	 be    found	on    http://www.ignavus.net/software.html
       <http://www.ignavus.net/software.html>

COPYRIGHT

       It is distributed under the GNU General Public License.

X OSD cat							   January 2001 						       XOSD(1xosd)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

Discussion started by: phani

2. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Discussion started by: sakthi.abdullah

3. Shell Programming and Scripting

error in passing a variable to sqlplus from a shell script

Discussion started by: kripssmart

4. Shell Programming and Scripting

Passing the unix variable to sqlplus

Discussion started by: Anaramkris