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

Reply via email to