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

QUERY: Get from VISIT to EO
DESCRIPTION I am trying to develop a query to aid in updating our rankings. It needs to include the eo data, the last obs date, and the first obs date. I ...
Mon, 9 Apr, 2018 at 3:43 PM
QUERY: Get code for an Oracle function or stored procedure
DESCRIPTION I would like to see the underlying code for some of the SQL functions that come with Biotics (there are some syntax issues that I could learn s...
Fri, 16 Nov, 2018 at 8:18 AM
Reason for Rank Change - S_RANK and ROUNDED_S_RANK
As part of the audit tracking procedures in Biotics, changes to s_rank and rounded_s_rank are routinely tracked in the audit log tables.However, the reaso...
Thu, 31 Dec, 2015 at 9:27 AM
QUERY: Find duplicate values within a table in Oracle
select column_name, count(column_name) from table group by column_name having count (column_name) > 1; This can be adjusted for selecting multiple co...
Mon, 9 Apr, 2018 at 3:23 PM
QUERY: Find views which reference a specific field/column name
Following is syntax for searching all views for a given field/column name.  In the example below, we're searching for OU_UID - make sure to replace th...
Mon, 9 Apr, 2018 at 3:21 PM
QUERY: Identify a record which references another and prevents its deletion
If you are trying to delete an EO, Managed Area, Reference, Conservation Site or other record, and you get an error message indicting that you can't d...
Mon, 9 Apr, 2018 at 2:36 PM
QUERY: preview first N-Number of records
The old Biotics4 Query Builder allowed you to preview N-number of results before running the query. Currently, Biotics5 doesn't have this functionality...
Mon, 9 Apr, 2018 at 2:33 PM
QUERY: export Source Features in a shapefile format that also displays Visit information
Because Source Features are points, lines, and polygons, the entire SF set has to be exported into 3 separate shapefiles. Attached is a file including the ...
Mon, 9 Apr, 2018 at 2:28 PM
QUERY: Parse scientific_name
The following query written by former staff of Kentucky State Nature Preserves Commission, Shauna Dunham, parses SCIENTIFIC_NAME: select replace(substr...
Mon, 9 Apr, 2018 at 2:26 PM
QUERY: Spatial Query of EOs within distance of Coordinates.
The following was provided by Greg Krakow of the Georgia Natural Heritage Program. The Oracle Spatial query below selects all eos within 5 kilimeters (500...
Mon, 9 Apr, 2018 at 2:25 PM