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
!!High Line supplied Functions
!!Personality supplied Functions
At line 14 changed one line
|[P2K_SMGLXMN]|Given a [Lexicon_Name|LEXICON_NAME] and [Stored_Value|LOW_VALUE] return the [Meaning|LEX_MEANING] value
|[P2K_SMGLXMN]|Given a [Lexicon_Name|LEXICON_NAME] and [Stored_Value|LOW_VALUE] return the [Meaning|MEANING] value
At line 32 added 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 39 changed one line
|[TO_DATE]|Converting a character field to a date (often with formatting)
|[TO_DATE(Oracle_Function)]|Converting a character field to a date (often with formatting)
At line 41 changed 2 lines
|[DATE FORMAT MODELS] for TO_CHAR and TO_DATE|Format mask options
|[NUMBER FORMAT MODELS] for TO_CHAR|Format mask options
|[DATE FORMAT MODELS (Oracle)] for TO_CHAR and TO_DATE|Format mask options
|[NUMBER FORMAT MODELS (Oracle)] for TO_CHAR|Format mask options
At line 61 added one line
|[EXTRACT]|Extracts a year, month or day value from a date
At line 59 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 12 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
----
![Notes|Edit:Internal.CALLABLE+FUNCTION]
[{InsertPage page='Internal.CALLABLE+FUNCTION' default='Click to create a new notes page'}]