oracle.query

Perform a direct Oracle query with minimal processing

A comprehensive data analysis framework for NIH-funded research that streamlines workflows for both data cleaning and preparing NIH Data Archive ('NDA') submission templates. Provides unified access to multiple data sources ('REDCap', 'MongoDB', 'Qualtrics') through interfaces to their APIs, with specialized functions for data cleaning, filtering, merging, and parsing. Features automatic validation, field harmonization, and memory-aware processing to enhance reproducibility in multi-site collaborative research as described in Mittal et al. (2021) <doi:10.20900/jpbs.20210011>.

Joshua G. Kenney

wizaRdry

A Magical Framework for Collaborative & Reproducible Data
Analysis

Trevor F. Williams

Minerva K. Pappu

Michael J. Spilka

Danielle N. Pratt 

Victor J. Pokorny

Santiago Castiello de Obeso

Praveen Suthaharan

Christian R. Horgan

oracle.query function

<dl><dt>query</dt>
<dd>The SQL query to execute</dd>
<dt>pii</dt>
<dd>Logical; if FALSE (default), remove fields marked as PII. TRUE keeps PII.</dd>
<dt>schema</dt>
<dd>Optional schema name to qualify table names in the query</dd></dl>

Arguments

Perform a direct Oracle query with minimal processing — oracle.query

<dl>

<dt>query</dt>
<dd>The SQL query to execute</dd>


<dt>pii</dt>
<dd>Logical; if FALSE (default), remove fields marked as PII. TRUE keeps PII.</dd>


<dt>schema</dt>
<dd>Optional schema name to qualify table names in the query</dd>

</dl>

Perform a direct Oracle query with minimal processing

oracle.query: Perform a direct Oracle query with minimal processing

Description

Usage

Value

Arguments