Answer Posted / 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 |
Post New Answer View All Answers
What is foreign key in sql with example?
What is the usage of the distinct keyword?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What does desc stand for?
What is the difference between joins?
What is the difference between a subquery and a join?
What is the syntax and use of the coalesce function?
discuss about myisam index statistics collection. : Sql dba
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is left join in sql?
Which is better trigger or stored procedure?
How does a covering index work?
Is null operator in sql?
What is sequence in sql?
Where is sql database stored?