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

diff b/w function and procedure?

Answer Posted / malkeet kaur

1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rollback truncate?

998


What are sql ddl commands?

1093


What are the different schemas objects that can be created using pl/sql?

1029


What is mutating sql table?

1112


How do you use collections in procedure to return the resultset?

2238


Explain constraints in sql?

1048


Could you please provide oca (oracle 10g) dumps for my certification ?

5169


What are all the common sql functions?

1030


What does 0 mean in sql?

965


Is a secondary key the same as a foreign key?

1038


how to add a new column to an existing table in mysql? : Sql dba

1073


What is a scalar value in sql?

1072


What is left inner join in sql?

1044


What are the advantages of pl sql over sql?

1025


How do I count records in sql?

1008