Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

State the difference between implict and explict cursor's?

Answer Posted / swapna

Implicit Cursor are declared and used by the oracle
internally. whereas the explicit cursors are declared and
used by the user.

more over implicitly cursors are no need to declare oracle
creates and process and closes autometically. the explicit
cursor should be declared and closed by the user.

More over Explicit Cursors were used to retrieve values
from two or more rows.

Is This Answer Correct ?    28 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the ddl commands?

1003


what is the difference between group by and order by in sql? : Sql dba

1113


What is snowflake sql?

1063


What is data abstraction in sql?

1016


What are the two parts of design view?

1011


What is normalization sql?

1049


how to use 'mysql' to run sql statements? : Sql dba

1040


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1338


Is sql a backend?

1007


What is use of package in pl sql?

1009


Can you have a foreign key without a primary key?

947


How to rename a column in the output of sql query?

1068


what is the difference between where clause and having clause? : Sql dba

992


Explain the difference between triggers and constraints?

967


what is union? : Sql dba

1019