摘要: from sqlalchemy import create_engine import pandas as pd import sqlalchemy.types as type from sqlalchemy.engine import Engine def connet_oracle(): ip_ 阅读全文
posted @ 2023-03-24 09:20 洺剑残虹 阅读(315) 评论(0) 推荐(0) 编辑
摘要: # -*- coding: utf-8 -*- import os import pandas as pd import cx_Oracle as cx # os.environ['path'] = r'D:\Program Files\plsql developer8.0\instantclien 阅读全文
posted @ 2023-03-24 09:15 洺剑残虹 阅读(69) 评论(0) 推荐(0) 编辑
摘要: # 导入需要的库 import pandas as pd import os def read_ddl_create_tab_sql(file_path:str,table_name:str): df = pd.read_csv(file_path,sep='\|\@\|',index_col=0, 阅读全文
posted @ 2023-03-24 09:08 洺剑残虹 阅读(94) 评论(0) 推荐(0) 编辑
摘要: import paramiko # pip install cx_Oracle -i https://mirrors.aliyun.com/pypi/simple/ host = 'ip' port = 22 username = '账户' password = '密码' remote_path = 阅读全文
posted @ 2023-03-24 09:06 洺剑残虹 阅读(261) 评论(0) 推荐(0) 编辑