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 are the advantages of normalization?
Can there be 2 primary keys in a table?
How do you handle exceptions. Give the syntax for it?
What is a recursive stored procedure?
Advantages and disadvantages of stored procedure?
Why is pl sql needed?
What is t sql used for?
What are the types of views in sql?
What is a database trigger?
Can we join 3 tables in sql?
How do you remove duplicate records from a table?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
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)