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 relationship? How many types of relationship are there?
What is the use of triggers?
What is materialized view. What are different methods of refresh?
What are the different ddl commands in sql?
What are all the common sql functions?
how to delete an existing column in a table? : Sql dba
What is foreign key sql?
What are all types of user defined functions?
what is the use of double ampersand (&&) in sql queries?
How to avoid duplicate records in a query?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is meant by Join? What are the different types of Joins available? Explain.
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)