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,
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
WOW ! all those new column names wth quirky names.
Well here is the procdure. make sure you got the GRANTs right
in order to compile it.
Also check to make sure I got the your_variable/my_variable match right.
hth
robert chin
CREATE OR REPLACE PROCEDURE table_fragmentation_info
( v_table IN
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
