What are cursors?

Answer Posted / swamy.l.n

1.A PRIVATE MEMORY/BUFFER.
2.IT IS USED TO HOLD THE DATA FROM TABLES OR VIEWS IN
MEMORY LOCATION FOR MANIPULATION PURPOSE.
3.VALID IN PL/SQL BLOCK ONLY.
4.ARE VARIABLE THAT YOU CAN DEFINE IN THE DECLARE SECTION
OF THE PL/SQL BLOCK.
ORACLE USES WORK AREA CALLED PRIVATE SQL AREAS TO EXECUTE
SQL STATEMENT AND STORE INFORMATION.
5.IT IS A VIRTUAL TABLE TO PROCESS MULTIPLE RECORDS IN
PL/SQL CONSTRUCT.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the key features of chameleon that separates it from other algorithms?

652


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1624


What do you mean by static and local variable?

513


How to test report in reportnet?

545


What is the difference between filter and lookup transformation?

585






Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1431


Explain why denormalization is promoted in universe designing?

530


Explain what is full load & incremental or refresh load?

510


What is surrogate key? Explain with examples.

580


Explain what are the mapping paramaters and maping variables?

536


What is the function of surrogate key in data warehousing?

603


Can we have multiple application.cfm file in an application?

460


What is the main difference between star and snowflake star schema? Which one is better and why?

538


Explain can report net connect multiple datasource at a time in report creation time?

470


What is data analytics in simple terms?

530