Oracle Functions, Procedures, Queries, Scripts, Views...
The attached function provides a way to put together a list of multivalued fields for a row, delimited by a character, such as | or ,. You most likely ...
Tue, 6 Nov, 2018 at 8:54 AM
Caution: These functions do not search for specific html tags. Instead they search for < and > and remove all text in between, including the < and ...
Mon, 9 Apr, 2018 at 10:24 AM
You give it the short_citation_author and short_citation_year and it will return all the short_citation_tiebreakers found in use for that combination. If nu...
Mon, 9 Apr, 2018 at 10:25 AM
Description: Does anyone out there have a function that will return elcode from eo_id, or element_subnational_id? Cause: Yes. A function to return elc...
Mon, 9 Apr, 2018 at 10:26 AM
Description: The attached getCLASSIFCODE function allows you to include the higher classification/taxonomy code for an element without linking to the highe...
Mon, 9 Apr, 2018 at 10:27 AM
Ampersand: SET DEFINE OFF removes SQL+'s special meaning for &, which is to turn a word into a variable. SET DEFINE OFF UPDATE EO SET DIRECTIONS =...
Mon, 9 Apr, 2018 at 10:28 AM
This function expands the EST_USESA function found in the Knowledge Base. It 'decodes' (spells out) the federal endangered species designations. Not...
Mon, 9 Apr, 2018 at 10:30 AM
Description: Line feed characters (chr(10) or ascii code Alt+012) have been found in Tracker text fields. They are invisible (they do not cause a line brea...
Mon, 9 Apr, 2018 at 10:37 AM
NOTE: As of 5.13.16, this will no longer be necessary, as we prepare to move towards postGres syntax in Biotics 6. -- This is the newer syntax for insertio...
Wed, 21 Aug, 2024 at 2:07 PM
The attached view will show the record id and record type that are associated with an element_global record. For each element_global, it will show: HIGHER_C...
Mon, 9 Apr, 2018 at 10:41 AM