{"id":1580,"date":"2017-11-28T13:34:48","date_gmt":"2017-11-28T06:34:48","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=1580"},"modified":"2025-05-26T06:56:04","modified_gmt":"2025-05-26T13:56:04","slug":"plsql-function","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-function\/","title":{"rendered":"PL\/SQL Function"},"content":{"rendered":"\r\n

Summary<\/strong>: In this tutorial, you’ll learn how to develop a PL\/SQL function to perform a specific task and return a value.<\/p>\r\n\r\n\r\n\r\n

Creating a PL\/SQL function #<\/a><\/h2>\r\n\r\n\r\n\r\n

In PL\/SQL, a function is a reusable code block that performs a specific task and returns a single value.<\/p>\r\n\r\n\r\n\r\n

Here’s the syntax for creating a function:<\/p>\r\n\r\n\r\n

CREATE<\/span> [OR REPLACE<\/span>] FUNCTION<\/span> function_name (\r\n    parameter1 datatype\r\n    parameter2 datatype\r\n) RETURN<\/span> return_type\r\nIS<\/span>\r\n   -- declarative section<\/span>\r\nBEGIN<\/span>\r\n   -- executable section<\/span>\r\n    \r\n   RETURN<\/span> value<\/span>;\r\n\r\n[EXCEPTION<\/span>]\r\n    [exception<\/span>-handling section]\r\nEND<\/span>;\r\n\/<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\r\n\r\n\r\n
A function consists of a header and body:<\/p>\r\n\r\n\r\n\r\n
The function body<\/strong>\u00a0is the same as the\u00a0procedure’s<\/a> body, which has three sections: declaration, execution, and exception handler.<\/span><\/p>\r\n\r\n\r\n\r\n
Function header<\/strong> consists of a function name and a RETURN<\/code> clause specifying the returned value’s datatype. Each parameter of the function can be either in the IN<\/code>, OUT<\/code>, or INOUT<\/code> mode. For more information on the parameter mode, check out the PL\/SQL procedure tutorial<\/a><\/p>\r\n\r\n\r\n\r\n