Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 28878 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / preethi
Cursors are work areas used for internal processing in
order toexecute an SQL statement.
Two tpes of Cursors
Implicit Cursors and Explicit Cursors.
Explicit Cursors can be further classifed into three
Named Cursors,Parameterized Cursors and Ref Cursors
| Is This Answer Correct ? | 28 Yes | 8 No |
Answer / daudkhan
A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.
Implicit cursor: Automatically declared
Explicit cursor: defined by programmer
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / banoj swain
cursor is nothing but a pointer pointing to the context area assigned by oracle for processing of sql statement.pl/sql programs control context area by using cursor.
types:1)static 2)dynamic or ref cursor
again static is of two types
1)explicit 2)implicit
dynamic of two types:
1)strong 2)weak
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / siva
cursor is nothing but buffer area it is process by multiple records and also record by record process.
they are two types
1.implicit cursor:- it is returned only single value.(it is created by default system )
2.explicit cursor:- it is returned multiple values.( it is created by user).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vishnuvardhan reddy
in db2 there are two types of cursors
1.scrolable cursor
2.non scrolable cursor
scrolable cursor:
scrolable cursor can be moved in sequential
forword (or)backword direction in the resultant table.
Non scrolable cursor:
simplest cursor is the non scrolable cursor
it is always moved in a sequential direction.
| Is This Answer Correct ? | 2 Yes | 10 No |
How to customize error conditions.
How you can make a parameterized view?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about post-relational databases?
How would you design a database for an online site, which would average a million hits a day?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
What is database design and development?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What are the main phases of database development?
Why does this query return 0?
What are the 18 schemas?
-
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)
