Difference between Procedure and Function ?<\/h2>\n<\/div>\n<\/div>\n

\n

\n

Procedure<\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n
• A procedure is a named PL\/SQL block which performs one or more specific task.This is similar to a procedure in other programming languages.<\/li>\n
• A procedure has a header and a body.<\/li>\n
• The\u00a0header<\/b>\u00a0consists of the name of the procedure and the parameters or variables passed to the procedure.<\/li>\n
• The\u00a0body<\/b>\u00a0consists declaration section, execution section and exception section similar to a general PL\/SQL Block. A procedure is similar to an anonymous PL\/SQL Block but it is named for repeated usage.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
  \n

  \n

  We can pass parameters to procedures in three ways<\/h2>\n<\/div>\n<\/div>\n

  \n\n\n\n\n\n\n

  Parameters<\/th>\n	Description<\/th>\n<\/tr>\n
  IN type<\/td>\n	These types of parameters are used to send values to stored procedures<\/td>\n<\/tr>\n
  OUT type<\/td>\n	These types of parameters are used to get values from stored procedures. This is similar to a return type in functions.<\/td>\n<\/tr>\n
  IN OUT type<\/td>\n	These types of parameters are used to send values and get values from stored procedures.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n \n \n Syntax<\/h2>\n <\/div> CREATE [OR REPLACE] PROCEDURE procedure_name (<Argument> {IN, OUT, IN OUT} <Datatype>,\u2026) IS Declaration section<variable, constant> ; BEGIN Execution section EXCEPTION Exception section END<\/code><\/pre> <\/div>\n<\/div>\n<\/div>\n \n \n Functions<\/h2>\n<\/div>\n<\/div>\n \n \n \n A function is a named PL\/SQL Block which is similar to a procedure.<\/li>\n The major difference between a procedure and a function is, a function must always return a value, but a procedure may or may not return a value.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n \n \n Syntax<\/h2>\n <\/div> CREATE [OR REPLACE] FUNCTION function_name [parameters] RETURN return_datatype; {IS, AS} Declaration_section <variable,constant> ; BEGIN Execution_section Return return_variable; EXCEPTION exception section Return return_variable; END;<\/code><\/pre> <\/div>\n<\/div>\n<\/div>\n \n \n Procedure vs function<\/h2>\n<\/div>\n<\/div>\n \n\n\n\n\n\n\n\n\n\n Procedure<\/th>\n Function<\/th>\n<\/tr>\n Used mainly to a execute certain process.<\/td>\n Used mainly to perform some calculation.<\/td>\n<\/tr>\n Cannot call in SELECT statement.<\/td>\n A Function that contains no DML statements can be called in SELECT statement.<\/td>\n<\/tr>\n Use OUT parameter to return the value.<\/td>\n Use RETURN to return the value.<\/td>\n<\/tr>\n It is not mandatory to return the value.<\/td>\n It is mandatory to return the value.<\/td>\n<\/tr>\n RETURN will simply exit the control from subprogram.<\/td>\n RETURN will exit the control from subprogram and also returns the value.<\/td>\n<\/tr>\n Return datatype will not be specified at the time of creation.<\/td>\n Return datatype is mandatory at the time of creation.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":" Answer : A procedure is a named PL\/SQL block…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[8028],"tags":[195,201,7760,360,203,199,214,209,283,205,8171,8151,8157,8160,8156,8178,8165,8177,8167,8166,8159,8179,8153,8169,8152,8164,8163,8155,8158,2936,8168,484,8175,8173,196,212,5941,286,207,204,15929,8181,208,206,8170,8154,8180,2677,975,200,8174,197,280,364,8162,8172,8161,8176,968,285,8150],"class_list":["post-1135","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-accenture-interview-questions-and-answers","tag-allstate-solutions-pvt-ltd-interview-questions-and-answers","tag-amdocs-interview-questions-and-answers","tag-atos-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-conduent-interview-questions-and-answers","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-difference-between-function-and-cursor","tag-difference-between-function-and-procedure","tag-difference-between-function-and-procedure-in-sql","tag-difference-between-function-and-procedure-in-sql-server","tag-difference-between-function-and-procedure-in-vb","tag-difference-between-function-and-procedure-in-vhdl","tag-difference-between-procedure-and-function-and-package-in-oracle","tag-difference-between-procedure-and-function-in-c","tag-difference-between-procedure-and-function-in-mssql","tag-difference-between-procedure-and-function-in-mysql","tag-difference-between-procedure-and-function-in-oracle","tag-difference-between-procedure-and-function-in-oracle-11g","tag-difference-between-procedure-and-function-in-pl-sql","tag-difference-between-procedure-and-function-in-tabular-form","tag-difference-between-stored-procedure-and-function","tag-difference-between-stored-procedure-and-function-in-mysql","tag-difference-between-stored-procedure-and-function-in-oracle","tag-difference-between-stored-procedure-and-function-in-sql","tag-difference-between-stored-procedure-and-function-in-sql-server","tag-fis-global-business-solutions-india-pvt-ltd-interview-questions-and-answers","tag-functions-and-procedures-in-sql","tag-genpact-interview-questions-and-answers","tag-how-to-call-a-procedure-in-oracle","tag-how-to-create-a-procedure-inside-a-package-in-oraclepl-sql-procedures-and-functions-with-examplere","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-infogain-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-oracle-corporation-interview-questions-and-answers","tag-polaris-financial-technology-interview-questions-and-answers","tag-procedures-and-functions-in-oracle-with-examples","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-similarities-between-function-and-procedurestored-procedure-vs-function-in-sql-server-performance","tag-stored-procedure-and-function-difference","tag-subroutines-functions-and-procedures","tag-synechron-technologies-pvt-ltd-interview-questions-and-answers","tag-tata-consultancy-service-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-turn-in-oracle-stored-procedure","tag-unitedhealth-group-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-difference-between-stored-procedure-and-function","tag-what-is-stored-procedure-in-oracle","tag-what-is-the-difference-between-function-and-procedure","tag-why-we-use-package-in-oracle","tag-wipro-infotech-interview-questions-and-answers","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers","tag-zensar-technologies-interview-questions-and-answers"],"yoast_head":"\n