A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types. Such information helps audit databases for ...
When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I look at ...
Have data sets scattered all over the place? Here's how to pull them into a single, robust catalog with the pointblank R package and a Quarto document. Do you have data sets scattered all over the ...