Function reference • dbutils

Connecting
`connect_to_database()`	Connect to an internal NEFSC database.
Get Functions that retrieve information from databases
`get_oracle_tables()`	Extract ALL oracle tables in database
Supporting
`create_species_lookup()`	Pair NESPP3, SVSPP3, Species_itis
`capture_function_call()`	Captures function call
Utility functions Functions called from other packages to format SQL statements
`createString()`	Utility function to convert argument to strings
`createStringSpecies()`	Utility function to convert NESPP codes to strings
`createStringYear()`	Utility function to convert argument to strings
`createTonnageString()`	Utility function to convert tonnage to strings
`create_species_lookup()`	Pair NESPP3, SVSPP3, Species_itis
`create_sql()`	called by many functions from several db packages to convert passed arguments to sql statements
`split_sql_query_nespp3()`	Splits a query into multiple parts, NESPP3 codes
`split_sql_query_svspp()`	Splits a query into multiple parts, SVSPP codes
Package Info
`dbutils` `dbutils-package`	dbutils: Utility functions to aid in database interactions

Reference