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 -> Re: Dinamic SQL

Re: Dinamic SQL

From: Tom Verhagen <tverhage_at_bart.nl>
Date: Mon, 25 Oct 1999 21:06:05 +0200
Message-ID: <7v29cp$m89$1@freyja.bart.nl>


you can f.e. use

** Built-in:  FORMS_DDL
** Example:   The expression can be a string literal.
*/

BEGIN
  Forms_DDL('create table temp(n NUMBER)');   IF NOT Form_Success THEN
    Message ('Table Creation Failed');
  ELSE
    Message ('Table Created');
  END IF;
END; copied from help form5

Starman heeft geschreven in bericht <7v1nus$tg3$1_at_draco.tiscalinet.it>...
>Hi all,
>
>I need to execute a SELECT statement but I want the "FROM table" variable.
>
>for ex. : SELECT * FROM <tablename>;
>
>where tablename is a variable.
>
>Is it possible? If not, is there another way?
>
>
>--
>Nino Stella
>Inteldata Srl
>email: ninomail_at_tin.it
>
>
>
>
Received on Mon Oct 25 1999 - 14:06:05 CDT

Original text of this message

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