What are the cursor attributes used in PL/SQL ?
Answers were Sorted based on User's Feedback
Answer / rajesh
The cursor attributes are
%rowcount
%found
%notfound
%isopen
if u have any issue contact me at
rajesh.natesh@gmail.com,rajesh.natesh@cognizant.com
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / pandu
Hi,
Cursor Attributes
1)Isopen
2)Found
3)Not Found
4)rowCount
but ,we cursor's are two types
Namely 1)Implicit Cursor
calling the attibutes as SQL%ISOPEN
2)Explicit cursor
calling the Attiributes as CursoName%ISOPEN.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / nishi
The cursor attributes are
%rowcount
%found
%notfound
%isopen
| Is This Answer Correct ? | 0 Yes | 0 No |
%type
%rowtype
contact me gireesh.p.v@gmail.com
| Is This Answer Correct ? | 1 Yes | 8 No |
What is an oracle stored procedure?
what is the difference between granting and creating a view?
What is the difference between delete and truncate statement in sql?
Is sql a microsoft product?
Where can I learn sql for free?
Is sql a scripting language?
What are all the common sql functions?
What is ON DELETE CASCADE?
How to rename a table?
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
How do I restart sql?
Why is a trigger used?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)