07-28-2006
hi
i tried your query. when i execute that i am getting an error like this "SQL plus cant be found" is there a way not to mention the user name and pwd in the script. thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status. (3 Replies)
Discussion started by: 98_1LE
3 Replies
2. Shell Programming and Scripting
Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
Discussion started by: lijju.mathew
1 Replies
3. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
4. Shell Programming and Scripting
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies
5. UNIX for Dummies Questions & Answers
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Discussion started by: nathanvaithi
3 Replies
6. Shell Programming and Scripting
Hi,
I need to call a shell script present on solaris server from within a PL / SQL block.
Kindly suggest..
Thanks
Sudhir (1 Reply)
Discussion started by: sudhird
1 Replies
7. Shell Programming and Scripting
Hi all,
My reqirenet goes like this.
Need to execute one select statement within the script and send a mail to the users with the number of records fecthed from the query.
Please help..
Thanks. (3 Replies)
Discussion started by: Achiever
3 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have one SQL file prepared in UNIX and one script that is executing that.
In SQL i have Update and create queries.
I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback.
I just have 1 create... (2 Replies)
Discussion started by: abhii
2 Replies
9. Red Hat
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies
10. UNIX for Beginners Questions & Answers
Hello~
I have a requirement to write a shell script which will connect to the oracle database and run a select count(*) query on a table.
The script should succeed only when the count returns a number greater than zero. If the count returns zero, the script should fail.
Can someone please... (3 Replies)
Discussion started by: Naren.N
3 Replies
LEARN ABOUT DEBIAN
rdf::redland::query
RDF::Redland::Query(3pm) User Contributed Perl Documentation RDF::Redland::Query(3pm)
NAME
RDF::Redland::Query - Redland RDF Syntax Query Class
SYNOPSIS
use RDF::Redland;
...
my $query=new RDF::Redland::Query($query_string); # default query language
my $results=$query->execute($model);
# or my $results=$model->query_execute($query);
while(!$results->finished) {
for (my $i=0; $i < $results->bindings_count(); $i++) {
my $name=$results->binding_name($i);
my $value=$results->binding_value($i);
# ... do something with the results
}
$results->next_result;
}
DESCRIPTION
This class represents queries of various syntaxes over an RDF::Redland::Model returning a sequence of results that (currently) bind
variable names to RDF::Redland::Node values.
CONSTRUCTORS
new QUERY-STRING [BASE-URI [QUERY-LANG-URI [QUERY-LANG]]]
Create a new RDF::Redland::Query object for a query string QUERY-STRING with optional base URI BASE-URI IN QUERY language QUERY-LANG or
query language URI QUERY-LANG-URI (both can be undef). If QUERY-LANG-URI is omitted, the current directory is used as the base URI.
If QUERY-LANG-NAME is undef, the default query language "rdql" is used. If BASE-URI is omitted, no base URI is used.
METHODS
execute MODEL
Run the query against model MODEL returning a RDF::Redland::QueryResults object or undef on failure.
SEE ALSO
RDF::Redland::QueryResults
AUTHOR
Dave Beckett - http://www.dajobe.org/
perl v5.14.2 2011-02-04 RDF::Redland::Query(3pm)