Passing string from bash to sqlplus Post: 303006863

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

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...

4. Shell Programming and Scripting

Passing Shell array to SQLPlus

Dears, Newbie here and tried to search this topic for 3 days now with results. I have a shell array and I want to use it in sqlplus with one connection. here is what I have for now #!/bin/ksh FileName=1000 FileName=2000 FileName=3000 FileName=4000 sqlplus /nolog <<EOF connect...

5. UNIX for Dummies Questions & Answers

Passing a Unix parameter to SQLPlus login command

hi All, i m trying to pass a user choice paramter from unix to sqlplus connect command here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance. sqlplus -s $1/$2 where $ 1 and $2 will b...

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 string as variable(s) in bash

I'm trying to write a basic bash script that takes input you give (what directory, if any, what name, if any ....) and passes the information to find. I'm trying to just create a string with all variables and then pass it to find. So far I have this extremely simple: #!/bin/bash -f ...

8. 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...

9. Shell Programming and Scripting

Passing string from SQL to a BASH script

OS Solaris 10, DB oracle 10g Hello, We currently have a BASH script that runs and moves image files from a remote server to the local db server. A snippet of the code shows that we are picking up all Images that are 'mtime -1' some code... for file in `ssh user@10.200.200.10 'find...

10. 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...

LEARN ABOUT REDHAT

ppmtopgm

ppmtopgm(1)						      General Commands Manual						       ppmtopgm(1)

NAME

       ppmtopgm - convert a portable pixmap into a portable graymap

SYNOPSIS

       ppmtopgm [ppmfile]

DESCRIPTION

       Reads  a  portable  pixmap  as  input.  Produces a portable graymap as output.  The output is a "black and white" rendering of the original
       image, as in a black and white photograph.  The quantization formula used is .299 r + .587 g + .114 b.

       Note that although there is a pgmtoppm program, it is not necessary for simple conversions from pgm to ppm , because any  ppm  program  can
       read  pgm  (and	pbm  ) files automatically.  pgmtoppm is for colorizing a pgm file.  Also, see ppmtorgb3 for a different way of converting
       color to gray.  And ppmdist generates a grayscale image from a color image, but in a way that makes it easy to differentiate  the  original
       colors, not necessarily a way that looks like a black and white photograph.

QUOTE

       Cold-hearted orb that rules the night
       Removes the colors from our sight
       Red is gray, and yellow white
       But we decide which is right
       And which is a quantization error.

SEE ALSO

       pgmtoppm(1),ppmtorgb3(1),rgb3toppm(1),ppmdist(1),ppm(5),pgm(5)

AUTHOR

       Copyright (C) 1989 by Jef Poskanzer.

								   10 April 2000						       ppmtopgm(1)

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

Passing the unix variable to sqlplus

Discussion started by: Anaramkris

4. Shell Programming and Scripting

Passing Shell array to SQLPlus

Discussion started by: roby2411