Hearing the Oracle

Home » Posts tagged 'PL/SQL'

Tag Archives: PL/SQL

Categories

GGPLOT Graphics for NFL Stats

May 2, 2015 8:41 PM / Leave a comment

GGPLOT2 is a package developed for producing graphics within the R statistical tool. It utilizes a layering metaphor for gradually adding visual details to the desired output. R can support datasets with millions of rows for various aggregation and analysis operations, but it can be slow, unwieldy to code in, and has memory limitations.     Continue…

De-duplicating Rows

March 26, 2015 5:19 PM / Leave a comment

dedup them!

dedup these hay-bogarting heffers for me!

Often the need arises to locate and remove duplicated rows, or partially duplicated rows from a table. Queries using the DISTINCT keyword (or it’s synonym UNIQUE) will retrieve and display rows without duplicates. But actually identifying and then removing the unwanted duplicates within a table represents a different level of work, and is also likely to involve greater resource consumption.     Continue…