Search Options
close
Search the following clips:
All Clips
Everyone's Clips
My Guides
Sign Up
Install
Learn More
Login
Dynamic cursors in PL/SQL
happydede
follow
0
9-23-2008 8:28 AM
94 views
Add a Comment
Login
to Comment. Not a member yet?
Sign up
Related Clips
Child killed for body parts
Temple of Artemis to be rebuilt
Levitation in the Lab
Brazil: Crop Circles
Inmate mails himself free
The Financial Cost of Feeling
Wave Powered Boat to cross Pacific!!!
More clips from
happydede
Varray in PL/SQL
Youtube a girmek için
Today's Top Clips
Sun + Water = Fuel
Weather Balloons To Control Climate
Nano Superbug-Killers -Identifies Bacteria That Have Become Resistant to Antibiotics
Photos Taken At Just the Right Angle
Obama names pro-net-neutrality FCC reviewers
Swapped bodies Experiment
Mind, body and goal: the embodied cognition revolution
The dance of consciousness
Back-to-School Season for Your Immune Cells
Working hard to be genius!
visit the
Top Clips page
View the Top Clips from
September 23, 2008
Embed This Clip In Your Site...
<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://www.clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/f3b4bd32-3b90-4597-a0b8-8e557712280d/D6BC183B-BD79-4342-947C-B4E60431943F/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.adp-gmbh.ch/ora/plsql/cursors/dynamic.html" href="http://www.adp-gmbh.ch/ora/plsql/cursors/dynamic.html" style="font-size: 11px;">www.adp-gmbh.ch</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.adp-gmbh.ch/ora/plsql/cursors/dynamic.html"><H1>Dynamic cursors in PL/SQL</H1></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.adp-gmbh.ch/ora/plsql/cursors/dynamic.html"><TR valign="top"><TD><H1>amic cursors in PL/SQL</H1></TD></TR><TR valign="top"><TD></TD><TD></TD><TD><DIV><PRE class="code">create or replace package dynamic_cursor is type t_crs is <A href="http://www.adp-gmbh.ch/ora/plsql/cursors/ref_cursors.html">ref cursor</A>; procedure dyn_sel ( tab_name in varchar2, field_name in varchar2, val in varchar2, crs in out t_crs); procedure openCursor; end dynamic_cursor; / create or replace package body dynamic_cursor as procedure dyn_sel ( tab_name in varchar2, field_name in varchar2, val in varchar2, crs in out t_crs) is stmt varchar2(100); begin stmt := 'select * from ' || tab_name || ' where ' || field_name || ' = :1 '; open crs for stmt using val; end dyn_sel; procedure openCursor is tc t_crs; f1 varchar2(50); f2 varchar2(50); begin dyn_sel('test_for_cursor','a','two',tc); loop fetch tc into f1,f2; exit when tc%notfound; dbms_output.put_line(f2); end loop; end openCursor; end dynamic_cursor; / begin dynamic_cursor.openCursor; end; / </PRE></DIV></TD></TR></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;"> </td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/D6BC183B-BD79-4342-947C-B4E60431943F/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>
Clipmarks
Home
New Clips
Top Clips
Dashboard
Popular Topics
News
Life
Science
Technology
Entertainment
Get Started
Sign Up
Install Clipping Tool
How Clipping Works
Clip-to-Blog™
ClipSearch
Tools and Resources
FAQ
ClipWeek
Top Clippers
Top Tags
Site Map
About Clipmarks
About Us
Contact
Blog
Copyright
Privacy
EULA
OK