Visit Our UNIX and Linux User Community


Rereiving variables


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Rereiving variables
# 1  
Old 11-05-2001
Question Rereiving variables

What is the best way to retrieve muliple variables back to a unix script from a record in oracle?? I'm using the Korn Shell on AIX.
# 2  
Old 11-05-2001
You'll have to experiment a bit but in general,
the form would be...

#!/bin/ksh
ORACLE_CONNECT_STRING=user/password@schema

numofrows=`sqlplus -s $ORACLE_CONNECT_STRING << EOF
set heading off
set verify off
set feedback off
set serveroutput on
declare cnt number;
begin
select count(*) into cnt from SOME_TABLE;
dbms_output.put(to_char(cnt));
end;
/
EOF`

echo "Number of rows: $numofrows"
exit 0


...again, I haven't actually tried this example but the sqlplus
part does work. I just am not quite sure if the variable assignemnt
will work this way. You might have to send the output to a file
then "read" the file into a list of variables (assuming more than
one column is selected.

Previous Thread | Next Thread
Test Your Knowledge in Computers #534
Difficulty: Medium
All programming languages have an explicit Boolean type.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to pass variables into anothother variables?

Below are three variables, which I want to pass into variable RESULT1 username1=userid poihostname1=dellsys.com port1=8080 How can I pass these variables into below code... RESULT1=$((ssh -n username1@poihostname1 time /usr/sfw/bin/wget --user=sam --password=123 -O /dev/null -q... (4 Replies)
Discussion started by: manohar2013
4 Replies

2. Shell Programming and Scripting

Passing awk variables to bash variables

Trying to do so echo "111:222:333" |awk -F: '{system("export TESTO=" $2)}'But it doesn't work (2 Replies)
Discussion started by: urello
2 Replies

3. Shell Programming and Scripting

BASH arrays and variables of variables in C++

Sometimes it is handy to protect long scripts in C++. The following syntax works fine for simple commands: #define SHELLSCRIPT1 "\ #/bin/bash \n\ echo \"hello\" \n\ " int main () { cout <<system(SHELLSCRIPT1); return 0; } Unfortunately for there are problems for: 1d arrays:... (10 Replies)
Discussion started by: frad
10 Replies

4. Shell Programming and Scripting

Running a script with multiple variables like 25 variables.

Hi All, i have a requirement where i have to run a script with at least 25 arguements and position of arguements can also change. the unapropriate way is like below. can we achieve this in more good and precise way?? #!/bin/ksh ##script is sample.ksh age=$1 gender=$2 class=$3 . . .... (3 Replies)
Discussion started by: Lakshman_Gupta
3 Replies

5. Shell Programming and Scripting

variables in variables ?

Hi Here is a simple code for (( c=1; c<=20; c++ )) do eval ff${c}=`cut -f$c -d, dupa` echo $ if != 0 ] ; then echo chuju fi done it works fine as long as file dupa contains integers, as soon as the cut chunks are like, for example,... (4 Replies)
Discussion started by: babulin2002
4 Replies

6. Shell Programming and Scripting

Variables

I need to define a variable of variable. I'll try to explain it. I've a list: LIST="aaa bbb ccc"I need to do something like: for word in LIST ;do res_$word=`ls $word` done This doesn't work. Any idea? Thanks (3 Replies)
Discussion started by: kekaes
3 Replies

7. Programming

How to convert byteArray variables to HexaString variables for Linux?

Hello everybody, I am having problem in converting byte array variables to Hexa String variables for Linux. I have done, converting byte array variables to Hexa String variables for Windows but same function doesn't work for linux. Is there any difference in OS ? The code for Windows is given... (2 Replies)
Discussion started by: ritesh_163
2 Replies

8. Shell Programming and Scripting

naming variables with variables

Hello, FIRST QUESTION: I am writing a script in which a query is taken at the beginning of the script to be later used at the end. In the query, variables are generated from a loop, and I would like to assign the variable NAME (not value) with an appended 1, 2, 3, 4.....n. The number of... (2 Replies)
Discussion started by: Allasso
2 Replies

9. Shell Programming and Scripting

non-variables with $

I am writing a csh script and I need to echo a word that starts with $ and is not a variable. How do I do that? (3 Replies)
Discussion started by: oprestol
3 Replies

10. UNIX for Dummies Questions & Answers

Using Variables to Set Other Variables

I have a script that I'm trying to shorten (below) by removing repetitive code. if ] then commodity_ndm_done=Y fi if ] then customer_ndm_done=Y fi if ] then department_ndm_done=Y fi if ] then division_ndm_done=Y fi (3 Replies)
Discussion started by: superdelic
3 Replies

Featured Tech Videos