raja, I would recommend that you heed Kevin's advise .. in the meantime .. here is a quick start e.g. for what you are looking to do ..
create procedure Blah ( para_owner in varchar2, para_table in varchar2) is cursor c1(v_owner varchar2, v_table varchar2) is select blah1 , blah1 , ... from bigBlah where blah= v_owner and bloh = v_table; begin for rec in c1(para_owner, para_table ) loop dbms_output.put_line(rec.blah1); dbms_output.put_line(rec.blah2); .... end loop; end; / hth Deepak --- Viraj Luthra <[EMAIL PROTECTED]> wrote: > Yeah I am reading, but if I could get a framework > for a procedure, referring to my sql's, then that > would be a big help. > > Please help. > > rgds, > > raja > -- > > On Wed, 28 Nov 2001 11:25:01 > Kevin Lange wrote: > >Two books ..... Oracle PL/SQL Programming .... and > Oracle Built-in > >Packages. Both from Steven Feuerstein on O'reilly > press. Good books for > >this. > > > >-----Original Message----- > >Sent: Wednesday, November 28, 2001 1:05 PM > >To: Multiple recipients of list ORACLE-L > > > > > >Hello all, > > > >I have attached an sql file containing a set of > sql's (6) of them, which > >gives me information regarding table fragmentation. > What I need to do is > >instead of writing seperate sql's, I need to write > a procedure, where in I > >pass the owner and table name and then the result > comes out, as you will see > >in the last sql. > > > >What I need is, if some one could please help in > writing a procedure? How to > >put cursors and use all the information in > different cursor variables etc. > > > >Please help. > > > >Thanks. > > > >Rgds, > > > >Raja > > > > > > > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >-- > >Author: Kevin Lange > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- (858) 538-5051 > FAX: (858) 538-5051 > >San Diego, California -- Public Internet > access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an > E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > >the message BODY, include a line containing: UNSUB > ORACLE-L > >(or the name of mailing list you want to be removed > from). You may > >also send the HELP command for other information > (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).