What is use of a cursor variable? How it is defined?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > Oracle

✍: Guest

Cursor variable is used to mark a work area where Oracle stores a multi-row query output for processing. It is like a pointer in C or Pascal. Because it is a TYPE, it is defined as TYPE REF CURSOR RETURN ;

2011-11-01, 2647👍, 0💬

What WHERE CURRENT OF clause does in a cursor?
What WHERE CURRENT OF clause does in a cursor? The Where Current Of statement allows you to update or delete the record that was last fetched by the cursor. 2011-11-02, 2940👍, 0💬

ADIDENT UTILITY is used for what ?
ADIDENT UTILITY is used for what ? ADIDENT UTILITY in ORACLE application is used to find version of any file . AD Identification. for ex. "adident Header <filename> 2011-10-28, 2892👍, 0💬

What is iAS Patch ?
What is iAS Patch ? iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shiiped as Shell scripts and you apply iAS patches by executing Shell script. Note that by default ORACLE_HOME is pointing to 8.0.6 ORACLE_HOME and if you are apply... 2011-11-03, 2832👍, 0💬

How do you pass cursor variables in PL/SQL?
How do you pass cursor variables in PL/SQL? Pass a cursor variable as an argument to a procedure or function. You can, in essence, share the results of a cursor by passing the reference to that result set. 2011-10-31, 2797👍, 0💬

How do you open and close a cursor variable. Why it is required?
How do you open and close a cursor variable. Why it is required? Using OPEN cursor_name and CLOSE cursor_name commands. The cursor must be opened before using it in order to fetch the result set of the query it is associated with. The cursor needs to be closed so as to release resources earlier than... 2011-10-31, 2787👍, 0💬

What are various options available with adpatch ?
What are various options available with adpatch ? Various options available with adpatch depending on your AD version are autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate 2011-10-28, 2727👍, 0💬

Can you apply patch without putting Applications 11i in Maintenance mode ?
Can you apply patch without putting Applications 11i in Maintenance mode ? Yes, use options=hotpatch as mentioned above with adpatch. 2011-10-27, 2695👍, 0💬

What is a cursor for loop?
What is a cursor for loop? A cursor FOR loop is a loop that is associated with (actually defined by) an explicit cursor or a SELECT statement incorporated directly within the loop boundary. Use the cursor FOR loop whenever (and only if) you need to fetch and process each and every record from a curs... 2011-11-03, 2694👍, 0💬

What should be the return type for a cursor variable. Can we use a scalar data type as return type?
What should be the return type for a cursor variable. Can we use a scalar data type as return type? The return type of a cursor variable can be %ROWTYPE or record_name%TYPE or a record type or a ref cursor type. A scalar data type like number or varchar can’t be used but a record type may evaluate t... 2011-11-01, 2670👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.