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 do u call in & out parameters for stored procedures?

Answer Posted / susila

create or replace procedure <pocedure_name>(x in number,y
out number) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(10,y);

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many sql statements are used? Define them.

1038


how to present a past time in hours, minutes and seconds? : Sql dba

1011


write an sql query to find names of employee start with 'a'? : Sql dba

1027


Is it possible to update views?

959


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1024


How do I edit a trigger in sql developer?

990


what is difference between delete and truncate commands? : Sql dba

1129


Is primary key a clustered index?

966


Which nosql database is best?

975


Who is the owner of mysql database?

1057


What is the order of sql select?

1041


What are instead of triggers?

1043


Explain character-manipulation functions?

1126


How is use pl and sql?

1059


What is procedure and function in sql?

997