Oracle Functions, Procedures, Queries, Scripts, Views...
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
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
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
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
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
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
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
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
-- 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
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