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 |
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is the largest value that can be stored in a byte data field?
What are pl/sql cursors?
How can we make an if statement within a select statement?
Which sql statement is used to delete data from a database?
What information is needed to connect sql*plus an oracle server?
Is sql port 1433 encrypted?
Write a sql select query that only returns each name only once from a table?
What has stored procedures in sql?
Can We write bulk collect statement in triggers?
write a query to delete similar records in different tables with same structure
Can we relate two different tables from two different users in ORACLE,PL/SQL?
Oracle (3253)
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)