Explain uses of cursor.
- 1 Answers
- 658 Views
- I also Faced
- E-Mail Answers
Answer / shwetha k
A cursor is a pointer to pointing to this memory area and used to retrieve data row by row instead of all row at a time.
select statement fetches only one row.so to overcome this problem cursor is used to hold the set of rows or data in one variable and can do whatever manipulation we want to do.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain ddl statements in pl/sql?
What mean sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are dml commands?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What are different types of tables in sql?
Which kind of parameters cannot have a default value in pl sql?
What is cartesian join in sql?
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
what is schema? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
how can we find the number of rows in a table using mysql? : Sql dba
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3303)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
