I need to save the result in variables or files with the same name ($SELECT_RESULT)
This sentence does not make any sense. Also your second and third queries are the same.
Please give a good clear example making it clear what is a file and what is a variable. Please make is clear whether any or all of them are different for each query.
You could combine the queries into one query:
Also personally I would use an Oracle "spool" command to write the results to a file (i.e. not a Shell redirect).
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Hi All,
Please help me to write a shell script to execute the below sql query.
select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery,
(select j.bill_no from
billinfo_T y,
bill_t j
where... (1 Reply)
I am using HP-UX:
I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is -
sqlplus user/temp1234 <<!
set serverout on
set feedback off
set pages 1000
set colsep ,
set echo off
spool /home/supp1/pks/output.csv... (8 Replies)
Hi,
I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data.
Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Hello ,
Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this..
How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies
LEARN ABOUT DEBIAN
rdf::redland::queryresults
RDF::Redland::QueryResults(3pm) User Contributed Perl Documentation RDF::Redland::QueryResults(3pm)NAME
RDF::Redland::QueryResults - Redland RDF Syntax Query Results Class
SYNOPSIS
use RDF::Redland;
...
my $query=new RDF::Redland::Query("query string", undef, undef, "sparql");
my $results=$model->query_execute($query);
# or my $results=$query->execute($model);
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;
}
The $results in the example is an object of class RDF::Redland::QueryResults.
DESCRIPTION
This class represents queries of various syntaxes over an RDF::Redland::Model returning a sequence of results that bind variable names to
RDF::Redland::Node values.
CONSTRUCTOR
There are no public constructors.
METHODS
count
Return the number of current results from the query.
finished
Return non-0 if the results have been exhausted.
binding_name INDEX
Get the name of variable binding INDEX in the array of variable names.
binding_names
Get the names all of the variable bindings as an array.
binding_value INDEX
Get the value of the variable binding INDEX in the current query result.
binding_values
Get the values of all of the variable bindings in the current query result.
binding_value_by_name NAME
Get the value of the variable binding NAME in the current query result.
bindings
Get the variable names and values of the current query result as a hash
bindings_count
Return the number of variable bindings.
next_result
Move to the next query result.
as_stream
Return a new RDF::Redland::Stream object representing the query results as an RDF Graph.
to_string [FORMAT-URI [BASE-URI]]
Serialize to a string syntax in format FORMAT-URI using the optional BASE-URI. The default format when none is given is determined by
librdf_query_results_to_string.
is_bindings
Return non-0 if the query results format is variable bindings
is_boolean
Return non-0 if the query results format is a boolean
is_graph
Return non-0 if the query results format is an RDF graph
get_boolean
Get the boolean query result; non-0 is true.
SEE ALSO
RDF::Redland::Query
AUTHOR
Dave Beckett - http://www.dajobe.org/
perl v5.14.2 2011-02-04 RDF::Redland::QueryResults(3pm)