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

QUERY: Get ranking, habitat, and management fields
The following query returns global rank factor, management, and characterization data, including the habitat fields with values comma-delimited. It is set u...
Mon, 9 Apr, 2018 at 1:38 PM
QUERY: Get data in an element working list
The following query will allow you to replicate what you see in an element working list. The Full ID and Geolevel columns are calculated values that are use...
Mon, 9 Apr, 2018 at 1:40 PM
QUERY: Data in a working list window
To query just those columns found in a working list (no other data from the records), you can take advantage of the views that exist in Biotics for all the ...
Mon, 9 Apr, 2018 at 1:45 PM
QUERY: Higher Taxon Family and Order with Taxonomic Sort
SELECT hcu_o.higher_class_unit_name as Tax_Order , hcu_f.higher_class_unit_name AS Family , sn.scientific_name AS Taxa , sn.author_name AS Author , eg.round...
Mon, 9 Apr, 2018 at 1:46 PM
QUERY: Habitat data from characterization fields
Runs off a working list and reports global habitat information for animals. Could be modified for use with plant elements and subnational data by substituti...
Mon, 9 Apr, 2018 at 1:47 PM
QUERY: Examples of querying the audit log
Here are some queries that you may find useful in querying the audit log. Basically, there are two tables that are important. Table AUDIT_LOG contains summa...
Mon, 9 Apr, 2018 at 1:48 PM
QUERY: Global USESA status and related data
/*This query returns USESA and related fields by Element ID, ELCODE, and Scientific Name. It lists the USESA Synonym, if one exists, but otherwise leaves th...
Mon, 9 Apr, 2018 at 1:49 PM
QUERY: Select values between two characters
Lets say you wanted to create a view that would select all the values between the first two astrices in a column you could say:  create view junk1 as select...
Mon, 9 Apr, 2018 at 1:50 PM
QUERY: Exporting Contacts to Outlook
Although Contacts have not been included in Biotics 5, the Contacts from your Biotics 4 database are still within the Biotics 5 databse.  Utilize the follow...
Mon, 9 Apr, 2018 at 1:51 PM
QUERY: Select EOs by Edauthor
/* This query selects all EOs with the selected edauthor names. To change the edauthor, move down to the WHERE clause to make the change. */ SELECT SCIENTI...
Mon, 9 Apr, 2018 at 3:25 PM