Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Rereiving variables
Top Forums Shell Programming and Scripting Rereiving variables Post 9898 by rwb1959 on Monday 5th of November 2001 11:22:05 AM
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.
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

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

LEARN ABOUT SUNOS

use

USE(1)								   User Commands							    USE(1)

NAME

       use - Frontend to the Usepackage Environment Manager

SYNOPSIS

       csh and derivatives:
	       source /usr/share/usepackage/use.csh

       bourne shell and derivatives:
	       source /usr/share/usepackage/use.bsh

       korn shell:
	       . /usr/share/usepackage/use.ksh

       use [-vs] [-f file] package ...

       use -l

DESCRIPTION

       Usepackage  is an environment management program. It is based on the principle of packages - collections of executables that share a common
       set of necessary environment variables, such as PATH, MANPATH or LD_LIBRARY_PATH.

       For each given package, use sources the appropriate environment information into the current shell.  The environment information is  speci-
       fied in a configuration file, see usepackage(1).

   OPTIONS
       -v     Output verbose information to the standard error stream.

       -s     Silence  warnings  for  un-matched  packages. This is useful in a shell rc script when a package is known not to be available on all
	      architectures that the shell is used on.

       -f file
	      Specify an alternate initial configuration file.

       -l     List available packages and groups.

FILES

       /usr/share/usepackage/usepackage.conf
		      The default configuration file.

       /usr/share/usepackage/use.csh
		      Shell setup for csh and derivatives.

       /usr/share/usepackage/use.bsh
		      Shell setup for bourne shell and derivatives.

       /usr/share/usepackage/use.ksh
		      Shell setup for ksh.

       /usr/bin/usepackage
		      The underlying Usepackage executable.

ENVIRONMENT

       Other than the reading and re-definition of environment variables for package setup, use also uses the following environment variables  for
       user configuration:

       PACKAGES_PATH  Colon-separated  path  list  giving  the directories to search for configuration files. Shell-style tilde (~) user-directory
		      escapes are expanded.

       HOME	      If present in the environment, this is used to provide the expansion for the tilde (~) user-directory.

       SHELL	      If present in the environment, the last path component of this is used for shell matching (see  SYNTAX)  and  detecting  the
		      style of environment output that should be used, see usepackage(1).

COPYRIGHT

       Usepackage Environment Manager
       Copyright (C) 1995-2005	Jonathan Hogg

       This  program  is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY	WARRANTY;  without  even  the  implied	warranty  of  MER-
       CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You  should  have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
       Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

SEE ALSO

       usepackage(1), csh(1), sh(1), ksh(1)

Usepackage						   $Date: 2005/12/11 16:42:09 $ 						    USE(1)
All times are GMT -4. The time now is 07:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy