This page (revision-15) was last changed on 26-Nov-2021 10:22 by khiggs

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 26-Nov-2021 10:22 5 KB khiggs to previous
14 26-Nov-2021 10:22 5 KB jaiken to previous | to last
13 26-Nov-2021 10:22 5 KB rforbes to previous | to last
12 26-Nov-2021 10:22 5 KB rforbes to previous | to last
11 26-Nov-2021 10:22 4 KB rforbes to previous | to last
10 26-Nov-2021 10:22 4 KB rforbes to previous | to last
9 26-Nov-2021 10:22 4 KB rforbes to previous | to last
8 26-Nov-2021 10:22 4 KB JMyers to previous | to last TO_DATE ==> TO_DATE(Oracle_Function)
7 26-Nov-2021 10:22 4 KB RForbes to previous | to last
6 26-Nov-2021 10:22 4 KB RForbes to previous | to last
5 26-Nov-2021 10:22 4 KB RForbes to previous | to last
4 26-Nov-2021 10:22 4 KB JAiken to previous | to last
3 26-Nov-2021 10:22 4 KB RForbes to previous | to last Callable Functio ==> CALLABLE FUNCTION
2 26-Nov-2021 10:22 4 KB RForbes to previous | to last Callable Function ==> Callable Functio
1 26-Nov-2021 10:22 4 KB RForbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 9 changed one line
!![{$applicationname}] supplied Functions
!!Personality supplied Functions
At line 33 added 2 lines
|[P2K_PMSEC.CHECKANDDECRYPT]|Decryption of [encrypted|ENCRYPTION] Varchar2 or Number data
|[P2K_PMSEC.CHECKANDDECRYPTDATE|P2K_PMSEC.CHECKANDDECRYPT]|Decryption of [encrypted|ENCRYPTION] date columns
At line 61 added one line
|[EXTRACT]|Extracts a year, month or day value from a date
At line 60 changed one line
|[MOD]|Modulus division (determining the remainder)
|[MOD] and [REMAINDER]|Modulus division (determining the remainder) or just returning the remainder
At line 72 added one line
|[NEXT_DAY]|Returns the first weekday that is greater than a specified date
At line 79 added one line
|[MAX] and [MIN]|Returns the maximum and minimum values from an expression
At line 82 added one line
|[SUM]|Returns the summed value of an expression
At line 84 added 5 lines
|[SQLCODE]|returns Oracle error message number from the most recently raised exception
|[SQLERRM]|returns Oracle error message text from the most recently raised exception
|[USER]|returns the Oracle database username of your session
|[UID]|returns the Oracle Session UserID number for your session
|[SYS_CONTEXT-USERENV]|Return various values related to your current database session