forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
66 lines
6.1 KiB
HTML
66 lines
6.1 KiB
HTML
<a name="EN-US_TOPIC_0000001764491940"></a><a name="EN-US_TOPIC_0000001764491940"></a>
|
|
|
|
<h1 class="topictitle1">PG_CURSORS</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000001764491940__a48cb99bfde1d4b47904c25a17d4a2a6e"><strong id="EN-US_TOPIC_0000001764491940__b5686161110306">PG_CURSORS</strong> displays available cursors.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491940__t3daa8f1c17004de3ba7ff00d1d4af81f" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_CURSORS columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001764491940__rc82e87b87b2341dbbba66dfc655157b9"><th align="left" class="cellrowborder" valign="top" width="18.459999999999997%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001764491940__ac6bed92e550641a38c3561096995d96b"><strong id="EN-US_TOPIC_0000001764491940__b19161199843644">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="17.91%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001764491940__a0c23c16a75d94938bf16a845582958a3"><strong id="EN-US_TOPIC_0000001764491940__b204131225184117">Type</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="63.629999999999995%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001764491940__a468f1c99dfce4ab6a0f7ffe7e8f6a2de"><strong id="EN-US_TOPIC_0000001764491940__b110512277416">Description</strong></p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001764491940__r3ac4fe9ba44245a389ea37f6a88a4efe"><td class="cellrowborder" valign="top" width="18.459999999999997%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491940__aec6f64b1fb0447ce81cc2c2d2bdf46cd">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.91%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491940__acf64382d4e834ba2bbe0803bc4cc7c43">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="63.629999999999995%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491940__a9ff9d798fa774e579937fa581294c191">Cursor name.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491940__r950f2113ea7c41cab131cdedc672ca4c"><td class="cellrowborder" valign="top" width="18.459999999999997%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491940__a69917a0ef40741ba831e2c0c2e54fb3e">statement</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.91%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491940__a0f0e834a80024b77aab20f78360284fe">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="63.629999999999995%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491940__acd4aaccf77c0411e91eee18467cb3d46">Query statement when the cursor is declared to change.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491940__rcfb541169fea4aadb373afe1100f07a2"><td class="cellrowborder" valign="top" width="18.459999999999997%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491940__a017844b94ebc48c5811091fd2711a240">is_holdable</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.91%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491940__afed552ccaee64baeadcb766976918a55"><span id="EN-US_TOPIC_0000001764491940__text1945211819325">boolean</span></p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="63.629999999999995%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491940__a689393a93fec4060abfb8249fd15f623">Whether the cursor is holdable (that is, it can be accessed after the transaction that declared the cursor has committed). If it is, its value is <strong id="EN-US_TOPIC_0000001764491940__b1691201733164959">true</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491940__r0cbe9a6903b744e08b4ad4a7095da1f7"><td class="cellrowborder" valign="top" width="18.459999999999997%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491940__a732dcfd6bafd41b3ba1dfaf575d3d286">is_binary</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.91%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491940__a5531e42b63a54c5f87b7b5d2016d07ab"><span id="EN-US_TOPIC_0000001764491940__text15262395322">boolean</span></p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="63.629999999999995%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491940__a0467c0e1cea2465690d74edc48a3d00a">Whether the cursor was declared BINARY. If it was, its value is <strong id="EN-US_TOPIC_0000001764491940__b974728144164848">true</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491940__re24844e7d45e4d7f8a3dfaf160dc7d1e"><td class="cellrowborder" valign="top" width="18.459999999999997%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491940__ae65c5b431c04424b896c13108679223a">is_scrollable</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.91%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491940__a0a647b26443d4b58bf8c5218f1ec5de5"><span id="EN-US_TOPIC_0000001764491940__text162008103320">boolean</span></p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="63.629999999999995%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491940__ab2ee95e62a1345969b8d66f28e4cc846">Whether the cursor is scrollable (that is, it allows rows to be retrieved in a nonsequential manner). If it is, its value is <strong id="EN-US_TOPIC_0000001764491940__b842352706164718">true</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491940__r1a7e0bb05bbe4f46abfc9a8744270cca"><td class="cellrowborder" valign="top" width="18.459999999999997%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491940__ac659214fce274f0fbdf16a4fba37a2d6">creation_time</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.91%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491940__ac43560950255417f9a6660174c172cda">Timestamp with time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="63.629999999999995%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491940__a959659cd79fe49779fbd66fe4a07678f">Timestamp of the cursor.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0639.html">System Views</a></div>
|
|
</div>
|
|
</div>
|
|
|