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

How many joins can you have in sql?

937


Why do we create views in sql?

1154


what is sql server agent? : Sql dba

1109


How long it takes to learn pl sql?

1010


What is %type in sql?

968


How many commands are there in sql?

1029


What is not equal in sql?

1124


What is java sql driver?

1124


What is a loop in sql?

986


how to drop an existing table in mysql? : Sql dba

1044


What is the difference between view and stored procedure?

959


What jobs use sql?

982


what is a record in a database ? : Sql dba

1063


Define select, insert, create, delete, update, drop keywords

1049


Does truncate table reset auto increment?

994