create_engine

oracle

EX

s_create_engine = f"oracle://{USER}:{base64.b64decode(PASSWORD).decode('utf-8')}@{HOST}:{PORT}/?service_name={SERVICE_NAME}&encoding=UTF-8&nencoding=UTF-8"

oracle默認使用cx_oracle，要記得加encoding避免中文亂碼

參考 https://docs.sqlalchemy.org/en/14/dialects/oracle.html#passing-cx-oracle-connect-arguments

!也可以用「connect_args」在create_engine時傳入(尚未測試)