| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need Help Please - With Procedures
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:Received on Wed Nov 28 2001 - 14:04:50 CST
>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: kgel_at_ppoone.com
>
>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: ListGuru_at_fatcity.com (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: viraj999_at_lycos.com 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: ListGuru_at_fatcity.com (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).
 |
 |