Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: set_block_propery
--------------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">
<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> The way to do it is:
<p> SET_BLOCK_PROPERTY('BLOCK_NAME',
DEFAULT_WHERE, CLAUSE)
<p> Where clause is a string, or string variable like
' ID_EMP=500'.
<br> Note that the where clause always have to begin
with a space. If you have a composed clause like:
<br> ' ID_EMP='||PARAMETER.ID_EMP
<br> you must use a string variable
</body>
</html>
Received on Mon Aug 21 2000 - 03:40:09 CDT