What is difference between cursor and ref cursor?
Answer / kiran r
Cursor is is pointer which is used access data retrived from database.Cursor is static in nature
ref cursor is datatype variable. whose memory address is working area query in database. it is dynamic in nature and it can be modified at the runtime
| Is This Answer Correct ? | 0 Yes | 0 No |
what is a cursor
i don't want the message as 14 rows updated just it should update what it will do
What is int identity in sql?
What jobs use sql?
How do I run a sql script?
What is the difference between local and global temporary table?
What is trigger in pl sql with examples?
Can you inner join the same table?
what are set operators in sql? : Sql dba
explain the difference between bool, tinyint and bit. : Sql dba
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
What is crud stand for?
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)