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...

How can you create Cursor with parametres ?

Answer Posted / madhuri

We can create cursor with parameters using parameterized
cursors.We declare the cursor in the deceleration section
with parameters.
Syntax: cursor <cursor_name>(parameters) is <select_stmt>

We pass values to these cursors while opening it.
open c1(100,'Computers');

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a constraint? Tell me about its various levels.

1241


What is a memo field?

1015


Which operator is used in query for pattern matching?

1126


What is record variable?

1032


What is the usage of when clause in trigger?

1087


What is trigger in pl sql?

1043


What are the basic sql commands?

1137


What is the use of count (*) in sql?

1113


Is sql procedural language?

1007


What view means?

1020


Explain locks? : Transact sql

1048


Are pl sql variables case sensitive?

1087


Explain how can you save or place your msg in a table?

1074


What is column?

1028


What is a pdo connection?

1109