Home -> Usenet -> comp.databases.oracle -> using parameters as it is in pl/sql queries

using parameters as it is in pl/sql queries

From: sudheer <y_sudheer_at_rediffmail.com>
Date: 9 Nov 2002 09:28:49 -0800
Message-ID: <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.
Received on Sat Nov 09 2002 - 18:28:49 CET












Original text of this message