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

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 ...
Fri, 24 Mar, 2017 at 8:27 AM
Function to 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 <...
Wed, 19 Nov, 2014 at 2:31 PM
Function to find out what 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. I...
Tue, 28 Oct, 2014 at 9:20 AM
Function to 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 t...
Tue, 28 Oct, 2014 at 1:51 PM
GetCLASSIFCODE function
Description: The attached getCLASSIFCODE function allows you to include the higher classification/taxonomy code for an element without linking to the hig...
Tue, 28 Oct, 2014 at 11:52 AM
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 DIRE...
Wed, 29 Oct, 2014 at 9:13 AM
Function to decode USESA designations.
This function expands the EST_USESA function found in the Knowledge Base. It 'decodes' (spells out) the federal endangered species designations...
Wed, 5 Nov, 2014 at 12:10 PM
Instructions to remove <strong> and <em> in rich text fields for biotics tables
Disable all triggers (see attached scfor tables that you want to apply The attached script is currently applied to EO, SOURCE_FEATURE, MA, CONSERVA...
Wed, 5 Nov, 2014 at 8:57 AM
Getting rid of "foreign" line feeds in 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 bre...
Tue, 28 Oct, 2014 at 1:43 PM
GETNEXTSEQ function
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'...
Thu, 31 Dec, 2015 at 10:39 AM