Data Warehousing Community Forum
February 08, 2012, 10:29:31 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
Databases
>
Oracle
>
PL/SQL
>
Cursor attributes in PL/SQL
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Cursor attributes in PL/SQL (Read 1131 times)
Sipra
Founder
Reputation: +59/-0
Offline
Posts: 323
Am the King...
Cursor attributes in PL/SQL
«
on:
June 28, 2007, 05:50:20 pm »
Hi All,
Let me know what are all the
Cursor attributes
used in PL/SQL?
Please define the function of each and every Cursor attribute?
Thanks...
Logged
Sipra
Founder
www.dwforum.net
Whoever
Administrator
Reputation: +34/-0
Offline
Posts: 124
Various Cursor attributes in PL/SQL
«
Reply #1 on:
June 29, 2007, 02:44:14 pm »
The Cursor attributes are as follows -
%ISOPEN -
To check whether cursor is open or not
%ROWCOUNT -
Number of rows fetched/updated/detected
%FOUND -
To check whether cursor has fetched any row. True is rows are fetched.
%NOTFOUND -
To check whether cursor has fetched any row. True is rows are not fetched.
These attributes are proceeded with
SQL for Implicit Cursors
and with
Cursor name for Explicit Cursors
.
Logged
If most people said what’s on their minds, they’d be speechless.
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA