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

QUERY: Find Invalid Objects and broken Views in your database
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...
Mon, 9 Apr, 2018 at 2:23 PM
QUERY/VIEW: Get the SQL behind a view via a query
You can use the following query to find the sql behind a view without having to go into SQL Developer or other Oracle database tool such as Toad: SELECT...
Mon, 9 Apr, 2018 at 2:20 PM
QUERY: Query the audit logs for rank changes
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
UPDATE: Append data via SQL
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