Re: plsql: for loop text variable
- From: bsh <brian_hiles@xxxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2011 15:29:56 -0700 (PDT)
On Oct 19, 7:19 am, jimmy <bigtoeh...@xxxxxxxxxxx> wrote:
Hi. I've posted this in the oracle group but since this place is a
lot busier....
Hi. I'm trying to use a varchar as the first part of a for loop in
plsql but can't find a way to make it work.
listCursor varchar2(100);
if x is not NULL then
...
Not that I am a PL/SQL expert, and certainly I am now a
bit rusty, but I see documented and have only used the
form:
if (x is not NULL) then ...
end loop;
The unbalanced loop block terminator of a code excerpt?
Any suggestions?
Try harder to determine the appropriate group to post queries?
There are many more resources available to the SQL &
PL/SQL programmer than Usenet. Search for a reply by
me for a list of recommended forae and resources on
the 'Net.
I also recommend using a PL/SQL IDE. Even the open-
source or freely-available ones do interactive syntax
flagging.
http://www.orafaq.com/tools
=Brian
.
- References:
- plsql: for loop text variable
- From: jimmy
- plsql: for loop text variable
- Prev by Date: Re: awk help!
- Next by Date: Re: how to get rid of wc's last total line
- Previous by thread: Re: plsql: for loop text variable
- Next by thread: symbolic link to existing directory
- Index(es):
Relevant Pages
|
