I need to get all the members information from an oracle table whose flag value is enabled. Later on i need to perform several computation based upon the flag value and other columns. For example,
I need to get only 1,3,4 details into a cursors as they have the flag enabled and then based upon the frequency i need to set some values and then based upon the flag i need to call different procedures.
Please help me out.
Moderator's Comments:
The structure of your table is invisible if it isn't in CODE tags. And, with CODE tags, it still isn't clear.
Last edited by Don Cragun; 08-27-2014 at 12:33 AM..
Reason: Add CODE tags.
Hello all,
I have a script that is fully functional and satisfactory in oracle. I recently started spooling it's output into unix for processing and manipulation. I do have a few problems however: The output of some columns are altered in the unix output:
1) On oracle, the date comes with a... (7 Replies)
Hi guys,
I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any?
Thanks for reading and in advance of posts,
B14... (2 Replies)
Hi
I connected to oracle database through shell script
My requiremnt is to get more than one record from the sql query.
How can i do in unix to get multiple records. (1 Reply)
Hi,
My Oracle Stored procedure returns sys_refcursor to shell script. I have to iterate through it in script and use those retrieved values further in my script. I am using K Shell Scrpting.
Stored Procedure is:
create or replace
PROCEDURE p_test(job_id IN VARCHAR2, c1 OUT SYS_REFCURSOR)... (0 Replies)
Hi,
My Oracle Stored procedure returns sys_refcursor to shell script. I have to iterate through it in script and use those retrieved values further in my script. I am using K Shell Scrpting.
Stored Procedure is:
create or replace
PROCEDURE p_test(job_id IN VARCHAR2, c1 OUT SYS_REFCURSOR)... (4 Replies)
Hi,
Please see contains both files created for automating the data from oracle through shell.
1)a_p.ksh
#!/bin/ksh
LOG=/home/A_P.log
MESSAGE=/home/MESSAGE_A_P.txt
mail_list=/home/AP_MAIL_LIST.txt
data=/home/spooled_A_P.log
echo "`date` Starting execution for A_P COUNT" > $LOG
... (2 Replies)
I am working in production support in an leading bank and more of my job is more in oracle/plsql. I am learning unix shell scripting and have started development in the same.I would like to know regarding the scope of these two in the industry.Also would like to know about other scripting... (2 Replies)
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT PHP
mongocollection.parallelcollectionscan
MONGOCOLLECTION.PARALLELCOLLECTIONSCAN(3) 1 MONGOCOLLECTION.PARALLELCOLLECTIONSCAN(3)MongoCollection::parallelCollectionScan - Returns an array of cursors to iterator over a full collection in parallel
SYNOPSIS
public array[MongoCommandCursor] MongoCollection::parallelCollectionScan (int $num_cursors)
DESCRIPTION
This method returns an array of a maximum of num_cursors cursors. An iteration over one of the returned cursors results in a partial set
of documents for a collection. Iteration over all the returned cursors results in getting every document back from the collection.
This method is a wrapper for the parallelCollectionScan MongoDB command.
PARAMETERS
o $num_cursors
- The number of cursors to request from the server. Please note, that the server can return less cursors than you requested.
RETURN VALUES
Returns an array of MongoCommandCursor objects.
EXAMPLES
Example #1
MongoCollection.parallelCollectionScan(3) example
Returning all documents in a collection by using multiple cursors.
<?php
$m = new MongoClient;
$c = $m->demo->cities;
/* Request three cursors */
$cursors = $c->parallelCollectionScan( 3 );
/* Add all the cursors to the MultipleIterator */
$mi = new MultipleIterator( MultipleIterator::MIT_NEED_ANY );
foreach ( $cursors as $cursor )
{
$mi->attachIterator( $cursor );
}
/* Iterate over all the associated cursors */
foreach ( $mi as $items )
{
foreach ( $items as $item )
{
if ( $item !== NULL )
{
echo $item['name'], "
";
}
}
}
?>
SEE ALSO
MultipleIterator, MongoCommandCursor, MongoDB::command.
PHP Documentation Group MONGOCOLLECTION.PARALLELCOLLECTIONSCAN(3)