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.
2018-11-11, 1382👍, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...