Re: Dynamic SQL?
From: David Sidwell <dasidwel_at_us.oracle.com>
Date: 1995/06/01
Message-ID: <dasidwel-0106951456460001_at_dasidwel-mac.us.oracle.com>#1/1
Date: 1995/06/01
Message-ID: <dasidwel-0106951456460001_at_dasidwel-mac.us.oracle.com>#1/1
In article <3qjr1v$6lo_at_tst.hk.super.net>, Mike Chan <mikechan_at_hk.net> wrote:
> Dear all,
>
> Can I have a sql statment like:
>
> select * from <variable>;
>
> in Oracle?
>
>
>
> Best Regards.
> Mike Chan
Yes - can do this as a precompiled dynamic SQL program, see one of the example dynamic Pro*C programs shipped with the product. Or you can do this in a stored procedure with release 7.1 and the DBMS_SQL package. Received on Thu Jun 01 1995 - 00:00:00 CEST