Welcome -
Guest!
Login
/
Register Now
|
Search:
Home
Articles
Forum
Interview FAQ
Activities
News
Videos
Poll
Links
People
Groups
SQL FAQ
Submit Interview FAQ
Home
»
Interview FAQ
»
SQL
RSS Feeds
What must be done after closing a cursor to return memory?
Shared By:
Shruti Sharma
Date:
Dec 21
Category:
SQL
Views:
1183
Answer:
You must deallocate the cursor. The syntax is
SQL> deallocate cursor cursor_name;
Share:
Previous Post:
What does the # in front of a temporary table signify?
Next Post:
Are triggers used with the SELECT statement?
Didn't find what you were looking for? Find more on
What must be done after closing a cursor to return memory?
Or get
search suggestion and latest updates
.
Related Topics:
What is memory mapping?
Basic concepts in memory interfacing
Using the CHECKS table, write a query to return all the unique remarks
Which overloads a unary minus operator and returns no values - Select option
return is an example of which option
Why am I getting an InvalidOperationException when I serialize an ArrayList?
How can I find out what the garbage collector is doing?
Distinguish between the memories mapped I/O peripheral I/O?
Which header file in C++ does contain function prototypes for memory allocation?
Which of the following character literal(s) does use two bytes of memory?
What will SELECT COUNT(*) FROM TEAMSTATS; query return?
What SELECT COUNT(LASTNAME) FROM CHARACTERS; will return?
Using the CHECKS table from earlier today, write a query to return just the check numbers and t
Do the following statements return the same or different output.
Your Comment
*
*
Comment should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].
Please login to post comment
Tagged:
what
must
be
done
after
closing
cursor
to
return
memory
Assembly Language
Artificial Intelligence
C Programming
C++ Programming
Visual C++
OOAD
Cobol
Java
SQL Server
Asp.net MVC
Rest and WCF Services
Entity Framework
Knockout.Js
Unix / Linux / Ubuntu
Networking
OOPs Concept
HTML
Dos
SQL
System Analysis & Design
Gadgets
Internet
CSS
Javascript
.Net Framework
Asp.net
C#
VB.Net
Python
Perl
Oracle
Software Engineering
RDBMS Terms
AJAX Framework
Design Pattern
UML
WPF
WCF
SEO
PowerShell
Visual Studio
WWF
BizTalk Server
Azure
General
Testing
Online Certifications
PHP
My SQL
LinQ
Project Management
Silverlight
XML
MS Office
Windows OS
DHTML
Sharepoint