1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
<html lang="en">
<head>
<title>gettingbindparameters - TOra</title>
<meta http-equiv="Content-Type" content="text/html">
<meta name="description" content="TOra">
<meta name="generator" content="makeinfo 4.13">
<link title="Top" rel="start" href="index.html#Top">
<link rel="up" href="common.html#common" title="common">
<link rel="prev" href="explainplan.html#explainplan" title="explainplan">
<link rel="next" href="objectdescription.html#objectdescription" title="objectdescription">
<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage">
<!--
This manual is for TOra, version 2.1.2+.-->
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
pre.display { font-family:inherit }
pre.format { font-family:inherit }
pre.smalldisplay { font-family:inherit; font-size:smaller }
pre.smallformat { font-family:inherit; font-size:smaller }
pre.smallexample { font-size:smaller }
pre.smalllisp { font-size:smaller }
span.sc { font-variant:small-caps }
span.roman { font-family:serif; font-weight:normal; }
span.sansserif { font-family:sans-serif; font-weight:normal; }
--></style>
</head>
<body>
<div class="node">
<a name="gettingbindparameters"></a>
<p>
Next: <a rel="next" accesskey="n" href="objectdescription.html#objectdescription">objectdescription</a>,
Previous: <a rel="previous" accesskey="p" href="explainplan.html#explainplan">explainplan</a>,
Up: <a rel="up" accesskey="u" href="common.html#common">common</a>
<hr>
</div>
<h4 class="subsection">3.9.3 Getting bind parameters</h4>
<p>This dialog is displayed when input parameters are required to run the SQL. For instance the example dialog is the dialog displayed when running the following SQL in the worksheet.
<pre class="example"><pre class="verbatim">
select * from essprc where prcid > :prcid and begrdt > :begrdt;
</pre>
</pre>
<div class="block-image"><img src="images/getparam.png" alt="images/getparam.png"></div>
<p>As you can see the field name as specified after the : character is presented as a title. If the same field name is used at several parts of the query you only get to specify it once. You specify the value in the editor line just to the right of the field name label. If you want to specify a NULL value check the <strong>NULL</strong> checkbox to the right of the editor. You can also edit the value in a memo editor(see <a href="memoeditor.html#memoeditor">memoeditor</a>) pressing the <strong>Edit</strong> button to the right on the value.
<p>The parameter editor will cache it's value so it will remember the last parameters you fed to it when you run the query again.
</body></html>
|
