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 / l..l.n.reddy

IMPLICT CURSOR:- Automatically porvide by oracle which
perform DML statements. queries returns only one row.

EXPLICT CURSOR:- Defined by user. queries returns more
than rows.

Is This Answer Correct ?    16 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum number of columns in sql table?

1087


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1114


Write the alter statement to enable all the triggers on the t.students table.

1066


How will you distinguish a global variable with a local variable in pl/sql?

1090


What is sql partition function?

1116


Which one is better sql or oracle?

902


What is %type in pl sql?

924


What is the difference between delete and truncate statement in sql?

1009


How many types of relationship are there?

973


which types of join is used in sql widely? : Sql dba

928


What's the difference between a primary key and a clustered index?

946


what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1089


What is memory optimized table?

984


What are % type and % rowtype?

979


Can instead of triggers be used to fire once for each statement on a view?

895