Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tablename as a paramter

Tablename as a paramter

From: Nicolas Bronke <NBronke_at_t-online.de>
Date: 12 Oct 1998 16:05:27 GMT
Message-ID: <6vt9c7$115$1@news01.btx.dtag.de>


Is it possible to place a tablename into the parameter list of a procedure/funtion?

e.g.

create function (tablename varchar2)
return number
as
  n number;
begin

   select count(*) into n from tablename;    return n;
end;

Kind regards
Nicolas Bronke Received on Mon Oct 12 1998 - 11:05:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US