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

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 Received on Sun Nov 10 2002 - 16:28:38 CET