Re: using parameters as it is in pl/sql queries

Ban Spam <ban-spam_at_operamail.com> writes:

> y_sudheer_at_rediffmail.com (sudheer) wrote in
> news:51715b1c.0211090928.6bf1516_at_posting.google.com:
>
> > hi,
> >
> > thanks in advance to the solution providers.
> >
> > this may be a silly doubt, but iam new to pl/sql.
> >
> > I have tables in my oracle db like
> > table01, table02, table03 .... all with same
> > structure but containing different records.
> >
> > now i have created a pl/sql block which will return
> > me the max(a_field) of a table.
> >
> > my necessity is that i want the same pl/sql function to
> > return the max(a_field) of the table, with the tablename
> > passed as the parameter to that pl/sql function,
> > other wise presently i am creating pl/sql function
> > for each table.
> >
> >
> > with best regards,
> >
> > sudheer y.
> >
>
> Try using EXECUTE IMMEDIATE

or a ref_cursor ?

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!