InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Create A Stored Function? |
|
Answer» 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 RETURN VARCHAR2 AS BEGIN RETURN 'FYICentere.com'; END; /Function created. 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: Function created. |
|