Oracle Functions, Procedures, Queries, Scripts, Views...

FUNCTION: DELIMLIST Function
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
FUNCTION: Remove ALL html tags from a string of text
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
FUNCTION: Determine tiebreakers are used for a reference
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
FUNCTION: Retrieve ELCODE_BCD for an EO
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
FUNCTION: GetCLASSIFCODE
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
INSERT/UPDATE: Allow the special characters ', &, and ; in SQL insert and update statements
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
FUNCTION: Decode USESA designations.
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
QUERY & UPDATE: Remove "foreign" line feeds from text fields
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
FUNCTION: GETNEXTSEQ
DESCRIPTION The GETNEXTSEQ function is used in an INSERT statement to get the next ID for a particular table for each new row in the table.  If you're ...
Mon, 9 Apr, 2018 at 10:38 AM
QUERY: Find records related to a specific EGT
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