Tags » Cursors

Advanced SQL - Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL

http://www.knowsh.com

Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL… 13 more words

Knowsh

Simple ETL process

Just lately I have been going back over CDC in SQL, I’m planning on taking the Microsoft Certs so I thought I better had :) and I wondered if a simpler process could be achieved, I wondered this as I wanted something simpler for my own stuff as I thought CDC was more than I needed. 943 more words

ETL

Multiplying rows by a factor in a column

The Problem

I had a table which represented clusters of an incident. I then wanted 1 row for every instance of that incidence. So, 248 more words

TSQL

Using Cursors on SELECT statements in store procedures

In store procedures, sometimes you need to get some specific value/s or the entire row/s then make some changes on them or send these values to another store procedures. 199 more words

Modify Select Statement

HDX: Enhanced Support for 3D and CAD Cursors with Citrix XenDesktop/XenApp 7.6 FP3

Citrix XenDesktop/XenApp 7.6 FP3 has introduced enhanced architecture to support both 24-bit and 32-bit advanced cursors. Historically remoting protocols have supported simpler cursors but with an increase in the use of complex and larger cursors for complex CAD and 3D applications, Citrix has introduced a new architecture to support such cursors on-going. 217 more words

XenApp

ORACLE: Looping through data using CURSORS

Below the syntax for creating the cursors in Oracle. This example also demostrates creating of procedures in Oracle


CREATE OR REPLACE PROCEDURE MYSCHEMA.GET_EMAILS AS

 EMAIL_ID VARCHAR2(100);
 
 CURSOR CUR IS SELECT EMAIL_ADDRESS FROM MYSCHEMA.USERS; /* DEFINE CURSOR */
 
BEGIN
 
 OPEN CUR; /* OPEN THE CURSOR */
 
 LOOP /* LOOP */
 
 FETCH CUR INTO EMAIL_ID; /* READ THE CURSOR VALUE */
 
 EXIT WHEN CUR%NOTFOUND; /* EXIT WHEN DATA NOT FOUND */
 
 DBMS_OUTPUT.PUT_LINE(EMAIL_ID); /* PRINT THE VALUE / PROCESS ACCORDING TO YOUR NEED */
 
 
 END LOOP; /* END OF LOOP */
 
 CLOSE CUR; /* FINALLY RELASE/CLOSE THE CURSOR */
END;
/

Happy Kooding.. Hope this helps!

Oracle

The Waiting Cursor

I am a writer.

You’ve no idea how long that phrase sat on my screen, the cursor blinking at me while I decided what should come next.  446 more words

Journaralities