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

How many columns should be in an index?

911


What is exit statement?

963


How many sql core licenses do I need?

892


Which normal form is best?

905


What do you mean by table in sql?

951


Can we commit inside a trigger?

950


Can we join same table in sql?

968


What does fetching a cursor do?

1029


What is microsoft t sql?

891


What is mutating table error?

1126


What is sqlite format?

1120


How can you tell the difference between an index and a view?

877


Explain scalar functions in sql?

1026


What are the ways on commenting in a pl/sql code?

1063


How do you add a column to a table?

1004