<div class="section" id="close-snowflake-scripting">
<h1>CLOSE(Snowflake Scripting)<a class="headerlink" href="#close-snowflake-scripting" title="제목 주소">¶</a></h1>
<p>지정된 커서를 닫습니다.</p>
<p>커서에 대한 자세한 내용은 <a class="reference internal" href="../../developer-guide/snowflake-scripting/cursors.html"><span class="doc">커서 작업하기</span></a> 섹션을 참조하십시오.</p>
<div class="admonition note">
<p class="admonition-title">참고</p>
<p>이 <a class="reference internal" href="../../developer-guide/snowflake-scripting/index.html"><span class="doc">Snowflake Scripting</span></a> 구문은 <a class="reference internal" href="../../developer-guide/snowflake-scripting/blocks.html"><span class="doc">Snowflake Scripting 블록</span></a> 내에서만 유효합니다.</p>
</div>
<dl class="field-list simple">
<dt class="field-odd">참고 항목</dt>
<dd class="field-odd"><p><a class="reference internal" href="declare.html"><span class="doc">DECLARE</span></a>, <a class="reference internal" href="open.html"><span class="doc">OPEN</span></a>, <a class="reference internal" href="fetch.html"><span class="doc">FETCH</span></a></p>
</dd>
</dl>
<div class="section" id="syntax">
<h2>구문<a class="headerlink" href="#syntax" title="제목 주소">¶</a></h2>
<div class="relative group text-sm"><div class="highlight-sqlsyntax notranslate"><div class="highlight"><pre><span></span><span class="k">CLOSE</span> <span class="s1">&lt;cursor_name&gt;</span> <span class="nx">;</span>
</pre></div>
</div><div data-codeblock-index="0" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<p>여기서:</p>
<blockquote>
<div><dl class="simple">
<dt><code class="samp docutils literal notranslate"><em><span class="pre">cursor_name</span></em></code></dt><dd><p>커서의 이름입니다.</p>
</dd>
</dl>
</div></blockquote>
</div>
<div class="section" id="usage-notes">
<h2>사용법 노트<a class="headerlink" href="#usage-notes" title="제목 주소">¶</a></h2>
<ul class="simple">
<li><p>커서가 닫힌 후에는 커서의 현재 행 포인터가 유효하지 않습니다. 커서를 다시 열면 커서가 새 결과 세트의 시작 부분에서 시작됩니다.</p></li>
</ul>
</div>
<div class="section" id="examples">
<h2>예<a class="headerlink" href="#examples" title="제목 주소">¶</a></h2>
<div class="relative group text-sm"><div class="highlight-sqlexample-lower notranslate"><div class="highlight"><pre><span></span><span class="ni">CLOSE</span> <span class="gi">my_cursor_name</span><span class="p">;</span>
</pre></div>
</div><div data-codeblock-index="1" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<p>커서 사용에 대한 보다 완전한 예는 <a class="reference internal" href="../../developer-guide/snowflake-scripting/cursors.html#label-snowscript-cursors-example"><span class="std std-ref">소개 커서 예</span></a> 를 참조하십시오.</p>
<p>루프를 사용하는 예는 <a class="reference internal" href="for.html#label-snowscript-for-example"><span class="std std-ref">FOR 루프 설명서</span></a> 에 포함되어 있습니다.</p>
</div>
</div>




CLOSE(Snowflake Scripting)¶

구문¶

사용법 노트¶

예¶