Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Common StatementsRSS Feeds

DECLARE CURSOR

Posted By: Callum Evans     Category: Oracle     Views: 3426

DECLARE CURSOR with example.

DECLARE CURSOR

declare cursor_name cursor
   for select_statement

DECLARE CURSOR statement creates a new cursor from the SELECT statement query. The FETCH statement scrolls the cursor through the data until the variables have been loaded. Then the cursor scrolls to the next record. 

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on DECLARE CURSOR Or get search suggestion and latest updates.

Callum Evans
Callum Evans author of DECLARE CURSOR is from London, United Kingdom.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!