PL/SQL (MOSC)

MOSC Banner

issue in for loop

edited Dec 30, 2013 7:53PM in PL/SQL (MOSC) 14 commentsAnswered ✓
Hi,

i have issue with PL/SQL loop code
i have 2 loops 

1st loop is to determine the count of numbers how the 2nd loop be executed 
2nd loop is to get a value from and assign it to a local variable

accordingly that variable holds the first retrieved value concatenated with #  --just as a separator-- and the second retrieved value concatenated with #  and so on 
but the small  bug i have that when the loop retrieves the last row the variable the # appear though there is no data after it
it works fine but if you have optimal coding for it

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center