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).
