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 is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?

Answer Posted / dinakar

Though Procedure returns a value through OUT parameter, it
cannot be used in SELECCT statement. Whereas a function can
be called in SELECT statement.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a database transaction? : Sql dba

1103


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

930


How do you go back in sql?

939


What is primary key and foreign key with example?

867


how to see the create table statement of an existing table? : Sql dba

945


What company owns postgresql?

960


how do you tune the slow running queries in oracle db , explain the methodology

2038


How can I tell if sql is running?

989


How do I run a sql trace?

903


Can we create view in stored procedure?

908


what are tables and fields? : Sql dba

987


How do I remove sql plus from windows 10?

1022


Why do we use cursors?

918


What is the maximum number of triggers, you can apply on a single table?

944


Why plvtab is considered as the easiest way to access the pl/sql table?

1127