Home > Topic List > oracle cursor usage

oracle cursor usage

Oracle cursor usage: 1. Explicit cursor, use the CURSOR keyword to define the cursor, and then specify the SELECT query statement in the cursor; 2. Implicit cursor, used to execute SQL statements in PL/SQL code; 3. Cursor attributes, use Used to obtain the current status of the cursor; 4. Cursor variables, variables used to reference the cursor object, and can be declared and used in PL/SQL blocks; 5. Cursor parameters, parameters of stored procedures or functions are passed. PHP Chinese website welcomes everyone to come and learn.

Related courses More >
ElementaryLearn Oracle from scratch

7316 times of learning

Collection
Elementaryoracle knowledge base

5108 times of learning

Collection
ElementaryXiao Wenji Oracle video tutorial

13491 times of learning

Collection
Related Tutorials More >