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

What are the modes of parameters that can be passed to a
procedure ?

Answer Posted / krupakar

Three Types of Parameters.
1) IN parameter mode- This mode is used to pass values to
the calling module when invoked.The value of IN parameter
can't be changed in the module.

2) OUT parameter mode -This mode is used to return a value
to the main block.The value of OUT parameter can change
anywhere in the program.

3)IN OUT parameter mode-This mode is used to pass values to
the calling module and return a value to the main block.The
value of IN OUT parameter can change anywhere in the
program.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

928


How do you copy a table in sql?

1008


what is a trigger? : Sql dba

972


How do I partition a table in sql?

1036


What is a primary key called that is made up of more than one field?

1279


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1000


What pl/sql package consists of?

1029


How to connect a sql*plus session to an oracle server?

1079


What is constant in pl sql?

965


How can we optimize a sql query?

982


Explain the significance of the & and && operators in pl sql.

949


what is user defined functions? : Sql dba

973


What is sql analyzer?

955


How do I run a query in pl sql developer?

925


what are the advantages of mysql in comparison to oracle? : Sql dba

936