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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: set_block_propery

Re: set_block_propery

From: sergio <smoriano_at_sicon.net>
Date: Mon, 21 Aug 2000 10:40:09 +0200
Message-Id: <10596.115073@fatcity.com>

--------------60A0D3B0D928241EDA9C4D78
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Slavica Sadzakovic wrote:

> Can somebody give me example for set_block_property procedure for > where clause.

Hi,

   The way to do it is:

       SET_BLOCK_PROPERTY('BLOCK_NAME', DEFAULT_WHERE, CLAUSE)     Where clause is a string, or string variable like ' ID_EMP=500'.     Note that the where clause always have to begin with a space. If you have a composed clause like:

       ' ID_EMP='||PARAMETER.ID_EMP
  you must use a string variable

--------------60A0D3B0D928241EDA9C4D78
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">

&nbsp;
<p>Slavica Sadzakovic wrote:
<blockquote TYPE=CITE><style></style>
<font face="Arial"><font size=-1>Can

somebody give me example for </font><font size=+0>set_block_property </font><font size=-1>procedure for </font><font size=+0>where </font><font size=-1>clause.</font></font></blockquote> Hi,
<br>&nbsp;&nbsp; The way to do it is:
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET_BLOCK_PROPERTY('BLOCK_NAME',
DEFAULT_WHERE, CLAUSE)
<p>&nbsp;&nbsp;&nbsp; Where clause is a string, or string variable like
' ID_EMP=500'.
<br>&nbsp;&nbsp;&nbsp; Note that the where clause always have to begin
with a space. If you have a composed clause like:
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ' ID_EMP='||PARAMETER.ID_EMP
<br>&nbsp; you must use a string variable
</body>
</html>
Received on Mon Aug 21 2000 - 03:40:09 CDT

Original text of this message

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