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, 2237🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...