Skip to content

Instantly share code, notes, and snippets.

@betterdatascience

betterdatascience/regression.sql

Created November 9, 2020 20:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save betterdatascience/6723cfc2adb6b0edd327084b532357fb to your computer and use it in GitHub Desktop.
Save betterdatascience/6723cfc2adb6b0edd327084b532357fb to your computer and use it in GitHub Desktop.
Download ZIP
005_sql_regression
Raw
regression.sql
BEGIN
DBMS_DATA_MINING.CREATE_MODEL(
model_name => 'GLMR_Regression_Housing',
mining_function => DBMS_DATA_MINING.REGRESSION,
data_table_name => 'housing_train_data',
case_id_column_name => 'row_id',
target_column_name => 'unitprice',
settings_table_name => 'housing_model_settings'
);
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment