Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Oracle cursors in UNIX shell scripting Post 302914589 by Krishraj on Tuesday 26th of August 2014 11:15:55 PM
Old 08-27-2014
Oracle cursors in UNIX shell scripting

Hello,

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,

Code:
Member ID              Flag                  Frequency         date
1                            A                               W                         26-08-2014
2                                                             M                          26-08-2014
3                            B                              W                          27-08-2014
4                            C                                W                          27-08-2014

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:
Mod Comment 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.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix and Oracle scripting

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)
Discussion started by: Khoomfire
7 Replies

2. Shell Programming and Scripting

Shell Scripting with Oracle...

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)
Discussion started by: B14speedfreak
2 Replies

3. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

4. Shell Programming and Scripting

UNIX shell scripting for retrieving from oracle

Hello folks, Please find the below code:(sample5.sh -> filename) echo "Selecting dat afrom Cause code" echo "set appinfo Causecode $preamble set serveroutput on size 10000 select * from RMI003_CAUSE_CODE /" | sqlplus -S $username@$hoststring/$password >> test2.dat When i tried executing... (5 Replies)
Discussion started by: sundar_ravi4
5 Replies

5. Shell Programming and Scripting

Can we write SQL cursors from shell script

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)
Discussion started by: vyagh
1 Replies

6. UNIX for Advanced & Expert Users

Need Help for Using Oracle Cursors in Shell Script Korn

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)
Discussion started by: rajeshorpu
0 Replies

7. Shell Programming and Scripting

Help need urgently for oracle cursors in k shell scripting

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)
Discussion started by: rajeshorpu
4 Replies

8. Shell Programming and Scripting

Help needed for shell scripting for oracle.

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)
Discussion started by: fidelis
2 Replies

9. Shell Programming and Scripting

scope of oracle plsql development /unix shell scripting

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)
Discussion started by: jesthomas
2 Replies

10. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

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
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)
All times are GMT -4. The time now is 11:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy