passing unix variable to sqlplus without a file name Post: 302099240

10 More Discussions You Might Find Interesting

1. Programming

Passing C Variable To Unix

I want to pass a variable set in my c program to a shell script (which will also be invoked or initiated from the same C program using the C's system command). Is it possible ? :confused:

2. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

hi fellows, can any body tell me how to pass unix variables to oracle code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE; is this is correct way........... Thanks in...

3. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Need to select count(*) from table to check for zero result in unix script

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

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

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

7. Shell Programming and Scripting

How to print huge values in sqlplus variable in UNIX?

Hi, I ahve a unix code as below. sqlTxt=$* sqlReturn=`echo "set feedback off; set heading off; set term off; set verify off; set serveroutput on size unlimited set lin 1000; VARIABLE GV_return_val NUMBER; VARIABLE GV_script_error varchar2(4000); EXEC :GV_return_code := 0; EXEC...

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. UNIX for Beginners Questions & Answers

Sqlplus variable UNIX

hi guys i have a sqlplus : sqlplus -s username/password << EOF @mysql.sql EOF in mysql.sql there is a count of a table, i want to write in a variabile unix. how can i do? Thanks a lot Regards Francesco.

LEARN ABOUT SUSE

gsl-randist

GSL-RANDIST(1)						      General Commands Manual						    GSL-RANDIST(1)

NAME

       gsl-randist - generate random samples from various distributions

SYNOPSYS

       gsl-randist seed n DIST param1 param2 [..]

DESCRIPTION

       gsl-randist  is a demonstration program for the GNU Scientific Library.	It generates n random samples from the distribution DIST using the
       distribution parameters param1, param2, ...

EXAMPLE

       Here is an example.  We generate 10000 random samples from a Cauchy distribution with a width of 30 and histogram them over the range  -100
       to 100, using 200 bins.

	    gsl-randist 0 10000 cauchy 30 | gsl-histogram -100 100 200 > histogram.dat

       A  plot	of  the  resulting histogram will show the familiar shape of the Cauchy distribution with fluctuations caused by the finite sample
       size.

	    awk '{print $1, $3 ; print $2, $3}' histogram.dat | graph -T X

SEE ALSO

       gsl(3), gsl-histogram(1).

AUTHOR

       gsl-randist was written by James Theiler and Brian Gough.  Copyright 1996-2000; for copying conditions see the GNU General Public Licence.

       This manual page was added by the Dirk Eddelbuettel <edd@debian.org>, the Debian GNU/Linux maintainer for GSL.

GNU
																    GSL-RANDIST(1)

10 More Discussions You Might Find Interesting

1. Programming

Passing C Variable To Unix

Discussion started by: kapilv

2. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

Discussion started by: chiru

3. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle

4. Shell Programming and Scripting

error in passing a variable to sqlplus from a shell script

Discussion started by: kripssmart