This query is with regards to a script (pl/sql) which returns multiple values.
Please see below script wherein the query returns a single value and is assigned to a single variable
Code:
DB_VALID_CDR=`sqlplus -s user/pass<<!EOF | grep -v "^Connected" 2>&1
set termout off echo off feedback off pause off timing off time off
set pages 0
clear breaks
clear compute
set termout on
select a.VALUE_INTEGER from client_statistics a, statistic_type b where a.STATISTICS_TYPE=b.Statistic_type_id and a.STATISTICS
_OBJECT like '%$VAR%' and b.STATISTIC_TYPE='valid_cdrs';
EXIT
!EOF`
Now if my sql query is modified to return mutliple values (columns, see below code) how can I get those values assigned in a variable/variables?
Code:
select STATISTICS_OBJECT, VALUE_INTEGER , START_PERIOD,END_PERIOD
from client_statistics
where
STATISTICS_TYPE=385
and to_char(sysdate,'dd/mm/yyyy HH24')=to_char(end_period,'dd/mm/yyyy HH24')
and VALUE_INTEGER > 0
and rownum=1
Finally this sql code will be embedded in a shell script
Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Hi guyz,
Posting a thread after a long time.
I want to pass two variables to unix shell script from sql script.
Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture... (3 Replies)
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname... (4 Replies)
I tried searching the forum for similar posts but its closed now.
Would appreciate any help on this.
I am trying to capture return value from a select query into a variable.
DB is Oracle
I am able to spool it to a file but I donot intend to use it.
Here is my script that does not work ;)
I... (27 Replies)
hi
I have two tables in oracle DB and am using a joining query which will result in the output as follows.
i need to assign it to a two dimensional array and use it for my further calculations.
the way i tried is as follows.
#!/bin/ksh
export... (1 Reply)
I have a log file that has certain fields that I want to evaluate, and depending on the value in those fields, I want to put the value of a different field in that line in a particular variable that I'll use later on down the log file. Sort of like setting a switch to change what I do with a bunch... (5 Replies)
For eg: I have sample.txt file with 4 rows of record like:
user1|password1
user2|password2
user3|password3
user4|password4
The username and password is sepsrated by '|'
I want to get the 1st row value from the file and assign it to two different variables(username and password)
in my... (1 Reply)
I have a file containing multiple values, some of them are pipe separated which are to be read as separate values and some of them are single value all are these need to store in variables.
I need to read this file which is an input to my script
Config.txt
file name, first path, second... (7 Replies)
The file1 contains mistakes and looks like
1 No one have never become rich by giving.
Anne Dickens
2 No one is worthless in this globe who lightens the weights of other.
Charles_Dickens
file2 contains the correction of words and looks like
rich poor
have has
never ever... (3 Replies)
Discussion started by: sammy777888
3 Replies
LEARN ABOUT DEBIAN
biomaj
biomaj(1) USER COMMANDS biomaj(1)NAME
biomaj - downloads and transform remote biological data banks
SYNOPSIS
biomaj [-h]
DESCRIPTION
BioMAJ (BIOlogie Mise A Jour) is a workflow engine dedicated
to data synchronization and processing.The Software automates
the update cycle and the supervision of the locally mirrored
databank repository. User must have roots rights to run biomaj.
OPTIONS -h display the list of commands.
INSTALL
At installation, BioMAJ requires a database to run (MySQL), installer should first create a database (biomaj_log) and a database user (the
one used at installation setup).
The database configuration for biomaj can be set or modified in /etc/biomaj/db_properties/global.properties.
In the install fails due to a SQL error, the install script must be manually run to create/upgrade the database:
perl /usr/share/biomaj/sql/migration/update.pl
The script will create/upgrade the database and update the configuration files.
ADMIN USER
A default admin user (admin) is created by the scripts. If using the biomaj-watcher, the default password (admin) MUST be changed immedi-
atly via the watcher interface.
If only biomaj core is used, password is useless.
.PP
UPGRADE
In the case of a package upgrade, if properly configured, the migration scripts will be ran automatically at install.
It is possible to run manually the script:
.B See perl /usr/share/biomaj/sql/migration/update.pl -h
for usage.
DATA BANKS
By default, biomaj is configured (data.dir in global.properties) to write banks to /var/lib/biomaj.
EXAMPLES
Update a bank:
biomaj --update genbank
Show console
biomaj --update genbank --console
Show status:
biomaj --status
EXIT STATUS
biomaj returns a zero exist status if it succeeds, it does not represent the bank update status.
AUTHOR
Olivier Sallou (olivier.sallou (at) irisa.fr) Romaric Sabas (romaric.sabas (at) irisa.fr)
version 1.2.0 September 14, 2011 biomaj(1)