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
!!Personality supplied Functions
!![{$applicationname}] supplied Functions
At line 32 removed 3 lines
|[P2K_PU]|A complete utility package of numerous functions used for the creation of interfaces and reports
|[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 42 changed one line
|[TO_DATE(Oracle_Function)]|Converting a character field to a date (often with formatting)
|[TO_DATE]|Converting a character field to a date (often with formatting)
At line 44 changed one line
|[DATE FORMAT MODELS (Oracle)] for TO_CHAR and TO_DATE|Format mask options
|[DATE FORMAT MODELS] for TO_CHAR and TO_DATE|Format mask options
At line 61 removed one line
|[EXTRACT]|Extracts a year, month or day value from a date
At line 63 changed one line
|[MOD] and [REMAINDER]|Modulus division (determining the remainder) or just returning the remainder
|[MOD]|Modulus division (determining the remainder)
At line 72 removed one line
|[NEXT_DAY]|Returns the first weekday that is greater than a specified date
At line 79 removed one line
|[MAX] and [MIN]|Returns the maximum and minimum values from an expression
At line 82 removed 7 lines
|[SUM]|Returns the summed value of an expression
|[COALESCE]|testing for and resolving multiple [NULL] values
|[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
At line 78 added 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 92 changed 2 lines
![Notes|Edit:Internal.CALLABLE+FUNCTION]
[{InsertPage page='Internal.CALLABLE+FUNCTION' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.CALLABLE+FUNCTION]
[{InsertPage page='Internal.CALLABLE+FUNCTION' default='Click to create a new discussion page'}]
}]