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

Home -> Community -> Usenet -> c.d.o.server -> Re: Issue SELECT against Forms Data Block

Re: Issue SELECT against Forms Data Block

From: Ian M. Meyers <meyersi_at_verinet.com>
Date: 2000/04/14
Message-ID: <38F7D21F.BC55973B@verinet.com>#1/1

In a single record block:

select :block.item_name
 into target_variable
from dual;

In a multi record block you must loop and check value.

ian

William wrote:

> My Question is can we Issue SELECT statement against Forms Data Block like
>
> select * from :<data_block_name>; ??
Received on Fri Apr 14 2000 - 00:00:00 CDT

Original text of this message

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