Oracle Functions, Procedures, Queries, Scripts, Views...
If you would like to quickly find all Invalid Objects, including broken views in your database, you can use the following query: SELECT owner,object_nam...
Tue, 14 Mar, 2023 at 7:49 AM
Run the following query in Query Builder to find the sql behind a view without having to go into SQL Developer or other Oracle database tool such as Toad : ...
Tue, 25 May, 2021 at 11:19 AM
Attached are 2 queries provided by the Frank Price of the Florida Natural Areas Inventory. The queries run surprisingly fast, even the more complicated one ...
Mon, 9 Apr, 2018 at 1:54 PM
Following is a SQL statement which allows you to append data to a field (via the double pipe || symbol) rather than overwriting the existing data: UPDATE Y...
Tue, 6 Nov, 2018 at 8:06 AM
The Ellink_report_by_WLID_LONG.rpt was created by Whitney Weber by copying the existing Ellink_report_by_WLID.rpt and altering it, and the Oracle views on w...
Thu, 8 Apr, 2021 at 2:20 PM
/** THREATS ASSESSMENT EXPORT--GLOBAL This query returns global Threats Assessment data for import into Threats Data Compiled. REMEMBER TO CHANGE WORKING ...
Tue, 17 Dec, 2024 at 2:22 PM
/** THREATS ASSESSMENT EXPORT--SUBNATIONAL This query returns subnational Threats Assessment data for import into Threats Data Compiled. REMEMBER TO CHANG...
Tue, 17 Dec, 2024 at 2:23 PM
Attached is a query to get Location Use Class. Note that you need to change the subnation_id as indicated in the comments.
Wed, 18 Dec, 2024 at 3:34 PM