Cursor Packages and Other Database Services

Maclean Liu(刘相兵

Cursor Packages and Other Database Services

On 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


Cursor Packages and Other Database Services.ppt (200.5 KB, 下载次数: 2, 售价: 10 金钱)

2012-3-21 21:33 上传

点击文件名下载附件
售价: 10 金钱  [记录]

回忆未来

谢谢 正需要下载看下