Oracle Variable Passing Test
I am trying to get the oracle variables and pass the values in sql placed in procedure.
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
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.
The UNIX and Linux Forums.
|Thread Tools||Search this Thread|
|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 03:01 PM|
|passing variable to oracle procedure||TimHortons||Shell Programming and Scripting||0||04-21-2009 11:44 AM|
|passing a variable inside a variable to a function||KingVikram||UNIX for Dummies Questions & Answers||2||01-14-2008 08:28 PM|
|Passing arrays to oracle from unix||satnamx||Shell Programming and Scripting||4||04-05-2006 07:08 PM|
|Passing arrays to oracle from unix||krishnasai||Shell Programming and Scripting||7||08-12-2002 08:01 PM|