Collections:
Create a Stored Function in Oracle
How To Create a Stored Function in Oracle?
✍: FYIcenter.com
A stored function is a function with a specified name and stored into the current database. If you want to create a stored function, you can use the CREATE FUNCTION statement. The example script below creates a stored procedure:
SQL> CREATE OR REPLACE FUNCTION GET_SITE 2 RETURN VARCHAR2 AS 3 BEGIN 4 RETURN 'FYICentere.com'; 5 END; 6 / Function created.
⇒ Call a Stored Function in Oracle
⇐ Pass Parameters to Procedures in Oracle
2018-11-11, 2650🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...