Oracle Variable Passing Test | Unix Linux Forums | Programming

  Go Back    


Programming Post questions about C, C++, Java, SQL, and other programming languages here.

Oracle Variable Passing Test

Programming


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 12-10-2012
Perlbaby Perlbaby is offline
Registered User
 
Join Date: Oct 2011
Last Activity: 24 June 2014, 9:17 AM EDT
Posts: 44
Thanks: 6
Thanked 0 Times in 0 Posts
Oracle Variable Passing Test

Hi,
I am trying to get the oracle variables and pass the values in sql placed in procedure.
VARIABLE
vstat='ASDS,FGDS,VCGD,VCXC'

Query :
select distinct dept from College
where section in ('C','D')
AND CODES =''
AND NAMES IN ('RAJ','SAM');

I want CODES values to be taken from vstat variable one by one in loop .
Here 4 values are passed seperated with comma. I need this query running for
individual codes 4 times. Based on num of parameter passed query should loop.u

Thanks .
Sponsored Links
    #2  
Old 12-10-2012
Scott's Avatar
Scott Scott is offline Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 26 July 2014, 4:30 AM EDT
Location: Zürich
Posts: 8,424
Thanks: 328
Thanked 1,029 Times in 900 Posts
Do not post classroom or homework problems in the main forums. Homework and coursework questions can only be posted in this forum under special homework rules.

Please review the rules, which you agreed to when you registered, if you have not already done so.

More-than-likely, posting homework in the main forums has resulting in a forum infraction. If you did not post homework, please explain the company you work for and the nature of the problem you are working on.

If you did post homework in the main forums, please review the guidelines for posting homework and repost.

Thank You.

The UNIX and Linux Forums.
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Passing unix variable to oracle parameters Jairaj Shell Programming and Scripting 17 04-08-2010 02:01 PM
passing variable to oracle procedure TimHortons Shell Programming and Scripting 0 04-21-2009 10:44 AM
passing a variable inside a variable to a function KingVikram UNIX for Dummies Questions & Answers 2 01-14-2008 07:28 PM
Passing arrays to oracle from unix satnamx Shell Programming and Scripting 4 04-05-2006 06:08 PM
Passing arrays to oracle from unix krishnasai Shell Programming and Scripting 7 08-12-2002 07:01 PM



All times are GMT -4. The time now is 05:08 AM.