Re: SELECT-statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 9 Mar 2001 19:08:28 +0100
Message-ID: <tai6t2eli22rcb@beta-news.demon.nl>

"André Klos" <andre.klos_at_pikon.com> wrote in message news:98b04l$dvh$1_at_piesbach.saarnet.de...
> Hi!
>
> How can I assign a table dynamically to a SELECT-statement? Is this
> possible?
>
> Thanks
>
> A.Klos
>
>
>
>

It is possible
In 8.0 and before you need to use the dbms_sql package to accomplish this. In 8i you can use Native Dynamic SQL (open <cursorvar> for <stringvar with sqlstatement>)
Please consult your pl/sql documentation and/or the book of Steven Feuerstein and/or Revealnet (www.reveal.net) for further details.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 09 2001 - 12:08:28 CST