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 pl sql architecture?
Explain 3 basic parts of a trigger.
What is sqlexception in java?
How to add, remove, modify users using sql?
what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
how do you know if your mysql server is alive? : Sql dba
What is the syntax to add a record to a table?
i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
Is sql an operating system?
How to create a menu in sqlplus or pl/sql?
What has stored procedures in sql?
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)