Re: pl/sql: determining table names at runtime?

Christian Bantzer wrote:
[snip]

> I would like to write a procedure which selects from a table which's name
> will be determined only at runtime. So I tried something along these
> lines:
>

Christian,

have a look at the dbms_sql package. This package offers dynamic creation of SQL statements during runtime.

HTH,

--
Dietmar Leibecke
debis Systemhaus GmbH
----------------------------
Opinions are mine and do not
necessarily reflect those of
my employer