plsql - How to Mimic a Continue Statement in a Cursor-For-Loop in Oracle 10G PL/SQL? -

-

in oracle 10g, there no continue statement. typically mimicked in explicit cursor such:

open c_cur ; <<cont>> loop     ...     if condition = 10         goto cont ;     end if; end loop; close c_cur ;

given loop keyword follows cursor in cursor-for-loop syntax, how can continue statement mimicked?

for rec in c_cur loop     ... end loop ; 

for rec in c_cur loop     ...     if condition = 10         goto cont ;     end if ;  <<cont>> null; -- end cannot preceeded <<marker>>  end loop ;

Comments

Post a Comment

Popular posts from this blog

Line ending issue with Mercurial or Visual Studio -

-
i seem have strange issue caused either visual studio or mercurial. localised single project, i'm guessing in project configuration causing issue. at difficult specify point, when perform action in visual studio, update every line ending in given file, means when @ file in sourcetree, every line has changed. i can replicate using nuget add package dependency; packages.config entirely replaced. if commit changes, including line endings, later same issue occur. workaround have shelve changes , reapply them, whereupon lines written correctly. i'm not sure application blame here. did make mistake of allowing sourcetree change mercurial configuration, issue have fixed, i'm not sure if has persisted. i thought might issue mercurial.ini files or hgrcs don't seem contain untoward. here's mercurial.ini [ui] username = .... [auth] bb.prefix = https://bitbucket.org/ bb.username = .... bb.password = .... [extensions] mq = rebase = [web] allow_push = * push_s...
Read more

R - Plot: How to format in 10-base scientific notation and put it text, mtex, title etc functions? -

-
i have numeric variable, k=3.5e-5 (its values calculated throughout script). want write value somewhere (title, text in plot, etc) in plot as: k_{root} = 3.5 10^{-5} cm /d i have tried functions bquote , substitute , no 1 worked. let's put question in examples. have tried following: 1) png("exp_1.png") kroot = 3.5e-5 plot(1:10,1:10, text(4,9,bquote(italic(k[root])~"="~.(kroot)~"cm/d"))) dev.off() try favorite function, paste(). plot(1:10,1:10, text(4,9,gsub("e",paste("k[root]=",format(k,scientific=true),"cm/d",sep=" "),replacement=" 10^"))) you can replace "e" here using function gsub. i've edited answer include this. the output: > k=.0000035 > k [1] 3.5e-06 > gsub("e",paste("k[root]=",format(k,scientific=true),"} cm/d",sep=" "),replacement=" 10^{ ") [1] "k[root]= 3.5 10^{ -06 } cm/d"...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more