07-31-2012
I don't think 'type=3' makes sense inside a select like that. I think you might be able to do '3 as type'.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In
unload to
"/usr/home/data.012202"
I wish to use a date variable as in
unload to
"/usr/home/data.`date`" for the file
is that possible in a query to do, or will i need to add a mv command after the query to do it.
I tried backquotes, , and () on `date` but didn't seem to work
Thanks... (2 Replies)
Discussion started by: Link_02
2 Replies
2. Shell Programming and Scripting
I have a script that looks for all jobs that contain a particular calendar.
Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?
I have tried:
select job_name from job where run_calendar='1&15dom'
select job_name from job... (3 Replies)
Discussion started by: Lindarella
3 Replies
3. Shell Programming and Scripting
Hi ...
I am doing a switch user and then rsh and then running a sql query .
I am successfull in rsh and logging into the database , but my query doesnt run ..
Here's the command :
su - linus -c "rsh -l linus psmf ORACLE_SID=SMP;export ORACLE_SID;sqlplus... (1 Reply)
Discussion started by: sars
1 Replies
4. UNIX and Linux Applications
Hello Everyone,
I am looking to write a script that will run on many machines in a network at the same time. They need to write a result to a common location. I plan to use a SQLlite database as this common writing point. But the concern I have is how SQLlite will react to multiple writes that... (1 Reply)
Discussion started by: garric
1 Replies
5. Shell Programming and Scripting
Hi,
I am passing an argument for the script and that argument values should exist in database.
bill_period_input="'""$1""'"
bill_period=`sqlplus uname/pwd@dbname <<eof!
set verify off
set heading off
set feedback off
select bill_period from bill_period_ref where... (4 Replies)
Discussion started by: ss_ss
4 Replies
6. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
7. Shell Programming and Scripting
Hi Everyone,
Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below
my file contains below data
R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20|
R1|Array/Network Resistor... (9 Replies)
Discussion started by: jam_prasanna
9 Replies
8. Shell Programming and Scripting
I used the following code
code
select * from tablename where columnname
Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem?
Thanks
Ananth (2 Replies)
Discussion started by: Ananthdoss
2 Replies
9. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
10. Programming
Hello All,
I hope I'm posting this in the right section.
I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Discussion started by: bbbngowc
8 Replies
LEARN ABOUT DEBIAN
search::gin::query::set
Search::GIN::Query::Set(3pm) User Contributed Perl Documentation Search::GIN::Query::Set(3pm)
NAME
Search::GIN::Query::Set - Create queries with set operations
VERSION
version 0.08
SYNOPSIS
# build a query like:
# (type:pdf OR type:png) AND (name:Homer OR name:Bart)
use Search::GIN::Query::Set;
use Search::GIN::Query::Manual;
my $query = Search::GIN::Query::Set->new(
operation => 'INTERSECT',
subqueries => [
Search::GIN::Query::Manual->new(
values => {
type => [qw(pdf png)]
}
),
Search::GIN::Query::Manual->new(
values => {
name => [qw(Homer Bart)]
}
),
]
);
DESCRIPTION
Creates a manual GIN query that can be used to search using basic set theory, in order to build more complex queries.
This query doesn't provide any specific search, it's just a set operator for subqueries. You can build complex queries by using other set
queries as subqueries for a set query.
METHODS
/SUBROUTINES
new
Creates a new query.
ATTRIBUTES
subqueries
The subqueries to process
operation
One of the basic set operators: "UNION", "INTERSECT" and "EXCEPT". The default is "UNION"
AUTHOR
Yuval Kogman <nothingmuch@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2010 by Yuval Kogman, Infinity Interactive.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.10.1 2011-01-31 Search::GIN::Query::Set(3pm)