데이터베이스 분석하기
필요한 패키지
if("rJava" %in% installed.packages("rJava") == FALSE)install.packages("rJava")
library(rJava)
if("DBI" %in% installed.packages("DBI") == FALSE)install.packages("DBI")
library(DBI)
if("RJDBC" %in% installed.packages("RJDBC") == FALSE)install.packages("RJDBC")
library(RJDBC)
if("dplyr" %in% installed.packages("dplyr") == FALSE)install.packages("dplyr")
library(dplyr)
if("data.table" %in% installed.packages("data.table") == FALSE)install.packages("data.table")
library(data.table)
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KIyMjIyMg642w7J207YSw67Kg7J207IqkIOu2hOyEne2VmOq4sA0KIyMjIO2VhOyalO2VnCDtjKjtgqTsp4ANCg0KYGBge3J9DQppZigickphdmEiICVpbiUgaW5zdGFsbGVkLnBhY2thZ2VzKCJySmF2YSIpID09IEZBTFNFKWluc3RhbGwucGFja2FnZXMoInJKYXZhIikNCmxpYnJhcnkockphdmEpDQppZigiREJJIiAlaW4lIGluc3RhbGxlZC5wYWNrYWdlcygiREJJIikgPT0gRkFMU0UpaW5zdGFsbC5wYWNrYWdlcygiREJJIikNCmxpYnJhcnkoREJJKQ0KaWYoIlJKREJDIiAlaW4lIGluc3RhbGxlZC5wYWNrYWdlcygiUkpEQkMiKSA9PSBGQUxTRSlpbnN0YWxsLnBhY2thZ2VzKCJSSkRCQyIpDQpsaWJyYXJ5KFJKREJDKQ0KaWYoImRwbHlyIiAlaW4lIGluc3RhbGxlZC5wYWNrYWdlcygiZHBseXIiKSA9PSBGQUxTRSlpbnN0YWxsLnBhY2thZ2VzKCJkcGx5ciIpDQpsaWJyYXJ5KGRwbHlyKQ0KaWYoImRhdGEudGFibGUiICVpbiUgaW5zdGFsbGVkLnBhY2thZ2VzKCJkYXRhLnRhYmxlIikgPT0gRkFMU0UpaW5zdGFsbC5wYWNrYWdlcygiZGF0YS50YWJsZSIpDQpsaWJyYXJ5KGRhdGEudGFibGUpDQpgYGANCg==