/* This query returns EOs from a specific surveysite. To change the surveysite name, move down to the WHERE clause */ SELECT SCIENTIFIC_NAME.SCIENTIFIC_NAM...

This is a example of a self join in SQL to find duplicate values and remove them. The first statement will select the duplicate items and the second will re...

This view is from Kee in Tennessee. Thanks!!! CREATE OR REPLACE VIEW ENV_REVIEW_VW AS SELECT EO.EO_ID, EO.SHAPE_ID, EOCODE_VW.EOCODE, D_NAME_CATEGORY.NAME_...

Here's a new view for higher taxonomy, called element_global_tax_search_vw. It replicates what the original element_global_tax_vw does, but it's mor...

Using a delimlist allows a query to return multiple values per record, concatenated into a single field. This is necessary in the case of one-to-many relati...

--This view was created by NatureServe for the --Kentucky State Nature Preserves Commission CREATE OR REPLACE VIEW HANDY_EO_VW (EO_ID, SHAPE_ID, EOCODE, SC...

The attached stored procedure populates the Elements grid within the Managed Area record (i.e. the element_managed_area table) based on data within the Mana...

The attached stored procedure checks your NEXT_SEQ table's values against the maximum primary key for each table in the NEXT_SEQ table. Install it by ru...

In Oracle 8i, you can use the functions in the DBMS_LOB package to do these comparisons. To compare two clob fields, here's the syntax: dbms_lob.compar...

I want to get some data out of the database on deleted records (EOs). Is that what the "deleted schema" is for? You want the deleted schema all r...