GeekArticles
FAQ
Oracle FAQForce cursor to reparse
Author: asktom.oracle.com |
Published: 3rd Jan 2008 |
Visited: 143 times |
Add CommentFiled in: Oracle FAQDear Tom,
We have an outbound interface, the specifications of which are mostly out of our control, where there is an "incremental" mode that is run nightly and a "full" mode that is done weekly. The interface involves dozens of large queries tha...
Read Article Sponsored Links
Related Articles
• Virtual Cursor This article demonstrates a new technique to optimize DBMS' output cursor storage using Virtual Cur ...
• CodeSnip: How to make use of parameterized cursor in Oracle Often it is convenient to pass a given set of values as input parameter to a cursor. It is very useful where nested cursors are used. Parameterizing the cursor makes it more usable and avoids the limitation of hard coding values in where the clause. In this code snippet, Deepankar examines this tech ...
• Question on Cursor Hi Tom,
Whats the difference between the below two
1.
DECLARE
CURSOR c1 IS SELECT ENAME,DNAME FROM emp A,dept B
WHERE A.deptno=B.deptno;
BEGIN
FOR i in c1 LOOP
----------
----------
------- ...
• Add a "allow cursor beyond end of line" option QC#: 44430 Version: 11.0 Status: Open defect, requires resolution Description: Delphi has a "Allow cursor beyond end of file" option, but hasn't anything for cursor beyond end of line.
For mouse-oriented user, or people like me frequently switching b ...
• Unable to store dynamic select into cursor Dear Tom,
I am writing a SP which is using two table as
CREATE TABLE TEST2
(
AGE NUMBER,
NAME VARCHAR2(60 BYTE),
EMPID VARCHAR2(60 BYTE)
)
INSERT INTO test2 VALUES (25,'sunil','7940');
CREATE TABLE INPUT_PARAM
(
CO ...
• adaptive cursor sharing in 11g hi tom
after reading your article about adaptive cursor sharing in 11g from
http://optimizermagic.blogspot.com/
I have some questions
1. Does oracle 11g calculate histograms for all tables and are histograms are enabled by default in 11g. ...
• CodeSnip: Practical Use of "for update of" in Oracle Cursor In this article, Deepankar examines the usage and application of the "for update of" cursor using Oracle 9i. He examines the concept with the help of a sample scenario. Initially, he provides the complete code listing followed by a detailed explanation. He finishes the discussion by examining the st ...