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

FUNCTION: USESA function for element_subnational (EST_USESA) and how to use it
The EST_USESA function: -- Returns the USESA status of an EST, when you pass in an element_subnational_id. -- Returns the first non-null value from these f...
Mon, 9 Apr, 2018 at 11:04 AM
PROCEDURE: Delete old working lists
Description: Procedure to delete old working lists: - older than a certain date OR - by user Solution: Here's a stored procedure that will delet...
Mon, 9 Apr, 2018 at 11:05 AM
FUNCTION: USESA function for EO (EO_USESA) and how to use it
The EO_USESA function: -- Returns the USESA status of an eo, when you pass in an EO_ID. -- Returns the first non-null value from these fields in this order...
Mon, 9 Apr, 2018 at 11:06 AM
PROCEDURE: Fix_eo_num (EO_AK3 constraint)
Description: A unique constraint error on BIOTICS_USER.EO_AK3 indicates that the EO_NUM being utilized already exists for that element. To rectify it you n...
Mon, 9 Apr, 2018 at 11:07 AM
FUNCTION: Informal taxonomy
This function lets you pass in an element_global_id and will return the NatureServe Explorer informal taxonomy or, conversely, specify an informal taxonomy ...
Mon, 9 Apr, 2018 at 11:10 AM
FUNCTION: Count the occurrences of a character in a field
Run the following while logged in as the biotics_dlink user to create the function: CREATE OR REPLACE FUNCTION COUNT_CHR (STRING VARCHAR2, CHARACTER VAR...
Mon, 9 Apr, 2018 at 11:11 AM
FUNCTION: USESA function for element_global (EGT_USESA) and how to use it
The EGT_USESA function: -- Returns the USESA status of an EGT, when you pass in an element_global_id. -- Returns the first non-null value from these fields...
Mon, 9 Apr, 2018 at 11:12 AM
INSERT/UPDATE: Keep rounded rank in sync with rank when doing SQL updates
When you make an update to an element_rank field (ELEMENT_GLOBAL.g_rank, ELEMENT_NATIONAL.n_rank, ELEMENT_SUBNATIONAL.s_rank) via a SQL update statement, yo...
Mon, 9 Apr, 2018 at 11:15 AM
FUNCTION: USESA function for element_national (ENT_USESA)
-- Returns the USESA status of an ENT, when you pass in an element_national_id. -- Returns the first non-null value from these fields in this order: -- taxo...
Mon, 9 Apr, 2018 at 11:16 AM
QUERY: Determine your program's ranking responsibility
If you want to see which plants you currently have global ranking responsibility for and you are using Biotics, here are two ways to do it. In either case, ...
Mon, 9 Apr, 2018 at 11:18 AM