plsqldeveloper - Looping through multiple results in PLSQL -


i have select query returns 50 results. select query returns id .

the next part need run select query value 50 ids.

please can 1 tell me best way done. using loop idea e.g.

begin declare  @count= select id table1   1 @count ..loop    select value table2 id =1 end loop 

can use cursors best method.

please elaborate on statement "the next part need run select query value 50 ids." however, if want fetch 50 records in pl/sql block , manipulate them in way, require cursor. records cursor can fetched both , without loop.

cursor example:

declare  cursor c1 select col1 table1; begin  in c1   loop    dbms_output.put_line(a.col1);   end loop; end; 

the above piece of code display values col1 when server output on.


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -