08-01-2008
Redirect Query o/p to variable
Hi,
I wanted to o/p the number of rows in a table to a variable in linux. How can i achieve this.
I wrote the query and its settings like feedback, pagesize line size in a file and using this file as a parameter to the sqlplus command. now can i redirect the o/p of that query to a variable.
Regards,
Swapna
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm trying to write a simple script program (C shell). I have a problem redirecting input into a variable. Say I have a variable called J, and there is file called result which contains just some number, say 5. Which command should I use to assign J value 5 from the file result. I tried the... (2 Replies)
Discussion started by: artur80
2 Replies
2. UNIX for Dummies Questions & Answers
how make assign the output of the command (for example: grep "file" "string" ) in a variable ($name)?
i thing how put the result of the command (grep , cut, find ecc) in a variable..
IT's Possible ?? (1 Reply)
Discussion started by: ZINGARO
1 Replies
3. UNIX for Dummies Questions & Answers
how do you redirect stdout into a variable. whenever I try I get an ambiguous redirect error :( I am trying to validate some user input and failing miserably.
cal $MONTH $YEAR | grep -c "$DAY"
if the above is 1 then it is valid if 0 then not valid. I have been trying to redirect the output... (2 Replies)
Discussion started by: MrAd
2 Replies
4. Shell Programming and Scripting
for the below
grep -i $1 "${logdir}"* | grep -i adding | grep -iv equation | tail -1 | cut -d ':' -f 1
the result of the grep i want to redirect into some variable, i tried to do
veri=grep -i $1 "${logdir}"* | grep -i adding | grep -iv equation | tail -1 | cut -d ':' -f 1
but it is... (2 Replies)
Discussion started by: mail2sant
2 Replies
5. Shell Programming and Scripting
hello
just i saw a really strange for cat
i have file (file1) contains line /home/rajiv/proj1/*.txt
now applied a commonds
DDPATH="$(cat file1)"
echo $DDPATH
it shows all the txt files in that folder like /home/rajiv/proj1/read1.txt /home/rajiv/proj1/read2.txt... (7 Replies)
Discussion started by: shailesh_arya
7 Replies
6. Shell Programming and Scripting
How to redirect postgresql select query to a variable using shell scripts?
I tried to use
psql -c "select ip from servers" db | egrep '+\.+\+\+' | sed 's/^ *\(.*\) *$/\1/'
Output:
10.10.10.180
10.10.10.181
It display ip addresses from the databasem, but how could i redirect the... (3 Replies)
Discussion started by: uativan
3 Replies
7. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
8. UNIX for Dummies Questions & Answers
How can I send the results of a query to a unix variable. I basically want to run a query then do some logic on the results. Trying to redirect the result into a variable I define in the script.
select count(*) as counter from table - nut to redirect the "count" returned from the query... (2 Replies)
Discussion started by: rstone
2 Replies
9. Shell Programming and Scripting
how to redirect printf to a variable (8 Replies)
Discussion started by: robo
8 Replies
10. Shell Programming and Scripting
I have shell script generate.sh that has
var="HP-UX"
I am following example 19-8 in the below document.
Here Documents
The output.txt is generated however I want the value of variable var to be reflected in the contents of the output.txt file
cat <<'EOF' #!/bin/bash
connect("Welcome... (1 Reply)
Discussion started by: mohtashims
1 Replies
LEARN ABOUT DEBIAN
plucene::search::query
Plucene::Search::Query(3pm) User Contributed Perl Documentation Plucene::Search::Query(3pm)
NAME
Plucene::Search::Query - base class for queries
SYNOPSIS
my $s_query = Plucene::Search::Query::Subclass->new({
boost => $boost_factor});
my $scorer = $s_query->scorer($query, $searcher, $reader);
DESCRIPTION
This is an abstract base class for queries.
A query is a specification of the content an properties of the desired documents. Every search is done by matching a query against the
document index and locating the ones that match the query.
The simplest query specifies a single term (or word) that is to be matched against a single field (e.g. 'author') of each of the documents
in the index. This kind of query matches any document that contains the term in the specified field.
A more complex queries may contain nested queries with 'and', 'or', 'not' or 'phrase' relations. Queries may also contains specification of
which document fields to match against the various parts of the query (.e.g. 'authors' and 'title') and hints that may effects the ranking
of the matched documents ('boost' factor).
METHODS
new
my $s_query = Plucene::Search::Query::Subclass->new({
boost => $boost_factor});
boost
Get / set this attribute
scorer
my $scorer = $s_query->scorer
(Plucene::Search::Query $query, $searcher, $reader);
prepare
Does nothing
sum_squared_weights / normalize / _scorer
These must be defined in a subclass
perl v5.12.4 2011-08-14 Plucene::Search::Query(3pm)