PL/SQL (MOSC)

MOSC Banner

Question abaout dinamic fields in types

edited Feb 18, 2015 10:00AM in PL/SQL (MOSC) 5 commentsAnswered

Greets,

I got this question:

I have a cursor that iterates a table. Each row is inserted into a type that is equal to the cursor row.

<span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">CURSOR</span><span class="pln" style="color: #000000;"> lc_lines </span><span class="kwd" style="color: #00008b;">IS</span><span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">SELECT</span><span class="pln" style="color: #000000;"> tlc1</span><span class="pun" style="color: #000000;">,</span><span class="pln" style="color: #000000;"> tlc2</span><span class="pun" style="color: #000000;">,</span><span class="pln" style="color: #000000;"> tlc3 </span><span class="kwd" style="color: #00008b;">FROM</span><span class="pln" style="color: #000000;"> table_x </span><span class="kwd" style="color: #00008b;">ORDER</span><span class="pln" style="color: #000000;"> </span><span class="kwd" style="color: #00008b;">BY</span><span class="pln" style="color: #000000;"> tlc1</span><span class="pun" style="color: #000000;">;</span><span class="pln" style="color: #000000;">  </span>

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