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 diffrence between function and procedure?

Answer Posted / raj dhar

Function :- Function always return one value.
Procedure :- Procedure may or may not be return value.

Function :- Function always required " RETURN " key word.
Procedure :- Procedure doesn't require " RETURN" key word.

Function :- Function we use parameter IN.
Procedure :- Procedure we use parameter IN,OUT,INOUT.

etc.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is oracle a programming language?

1035


How is it different from a normal table?

1078


How to use values from other tables in update statements using oracle?

1119


What is oracle rowcount?

1143


How to select some columns from a table in oracle?

1168


How to view existing locks on the database?

1098


How to define and use table alias names in oracle?

986


What are the benefits of ordbms?

1136


State and explain about oracle instance?

1048


How do I call oracle stored procedures that take no parameters?

1193


What is the recommended interval at which to run statspack snapshots, and why?

2962


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383


What is coalesce function?

1139


How to use like conditions in oracle?

1111


How to get a create statement for an existing table?

1010