Answer Posted / vipin kumar ( m.c.a)
Cursor is a private SQL work area to perform an action using
PL/SQL statement. DBA allocate the memory space to the
objects that is area is called the cursor.
Cursor has two types-
1. Implicit cursor:- means predefine cursor.
2. Explicit cursor:- means created by the user or programmer.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many types of auditing in Oracle?
What is partitioned table in Oracle?
Explain about the analyze command in oracle?
Explain an exception and its types?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
List out the types of joins.
How to get maxsal , minsal, ename department wise in single query
Give the various rollback segment states.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to write a query with a left outer join in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How will you identify oracle database software release?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the simplest tool to run commands on oracle servers?
What is connection pool in oracle?
