How do you pass cursor variables in PL/SQL?

.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

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, 3132👍, 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, 3210👍, 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, 3204👍, 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, 3133👍, 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, 3101👍, 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, 3050👍, 0💬

How you put Applications 11i in Maintenance mode ?
How you put Applications 11i in Maintenance mode ? Use adadmin to change Maintenance mode is Oracle application. With AD.I you need to enable maintenance mode in order to apply application patch via adpatch utility. If you don't want to put application in maintenance mode you can use adpatch options... 2011-10-27, 3017👍, 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, 3005👍, 0💬

What are things you do to reduce patch timing ?
What are things you do to reduce patch timing ? You can take advantage of following - # Merging patches via admrgpch # Use various adpatch options like nocompiledb or nocompilejsp # Use defaults file # Staged APPL_TOP during upgrades # Increase batch size (Might result into negative ) 2011-10-26, 3002👍, 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, 2985👍, 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.