Quick Search:
 
 Oracle PL/SQL: FUNCTIONS: Deterministic Jump to:  
Category: >> Oracle PL/SQL >> FUNCTIONS: Deterministic  

<< lastnext >>

Snippet Name: FUNCTIONS: Deterministic

Description: Deterministic functions do not reference tables and always return the same result, based upon input, every time they are called.

Also see:
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» SUBST and INSTR together
» INSTR (InString)
» SUBSTR (SubString)
» String Functions: REVERSE
» String Functions: LENGTH
» String Functions: INSTR
» String Functions: CONCAT
» String Functions: CHAR
» String Functions: INITCAP
» String Functions: LOWER
» String Functions: UPPER
» Date Functions: NUMTOYMINTERVAL
» Date Functions: NUMTODSINTERVAL

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 13th, 2009

Functions Deterministic 
<parameters> [IN | OUT | IN OUT] [NOCOPY] <data_type>)
DETERMINISTIC
RETURN <data_type> [AUTHID <CURRENT_USER | DEFINER>] IS
 
<constant, EXCEPTION, AND variable declarations>
 
BEGIN
  <code_here>;
END <function_name>;
/ 
CREATE OR REPLACE PACKAGE fd_demo IS
 td DATE;
 
 FUNCTION get_date RETURN DATE;
 FUNCTION get_date_determ RETURN DATE DETERMINISTIC;
END fd_demo;
/
 
CREATE OR REPLACE PACKAGE BODY df_demo IS
 
 FUNCTION get_date RETURN DATE IS
 BEGIN
   RETURN df_demo.td;
 END get_date;
 
 FUNCTION get_date_determ RETURN DATE DETERMINISTIC IS
 BEGIN
   RETURN df_demo.td;
 END get_date_determ;
 
END df_demo;
/ 
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org