Cursor Packages and Other Database Services
Cursor Packages and Other Database ServicesOn SOA and APIs
What is a cursor?
What is a cursor package?
Using cursor packages in PL/SQL and Java
Advantages of cursor packages
Some other APIs
Arguments provide data to be stored
Arguments specify data to be retrieved
Result
Confirmation that data was stored
Result or Result Set
In Oracle, APIs are usually written in PL/SQL
Use them from ANY Language
What is a Cursor?
A Data Structure
A Container for SQL Commands
A Pointer to Result Rows
ALL Commands use one
Explicit cursors usually for SELECT
That's how we'll use it here
谢谢 正需要下载看下
页:
[1]