摘要:
from sqlalchemy import create_engine import pandas as pd import sqlalchemy.types as type from sqlalchemy.engine import Engine def connet_oracle(): ip_ 阅读全文
摘要:
1、行专列函数 CREATE OR REPLACE FUNCTION SPLIT_STR(P_STRING VARCHAR2, P_SEP VARCHAR2 := ',') RETURN TYPE_SPLIT PIPELINED IS /* 创建TYPE类型 CREATE OR REPLACE TY 阅读全文
摘要:
1、pandas指定类型插入Oracle数据库 import pandas as pd import sqlalchemy.types as type from connet_ora import connet_oracle # 链接Oracle engine = connet_oracle() d 阅读全文
摘要:
import tensorflow.compat.v1 as tf # from tensorflow.examples.tutorials.mnist import input_data import os import pandas as pd import numpy as np from t 阅读全文
摘要:
CREATE OR REPLACE PROCEDURE EXP_SQL_TO_CSV(P_QUERY IN VARCHAR2, -- PLSQL文 P_DIR IN VARCHAR2, -- 导出的文件放置目录 P_FILENAME IN VARCHAR2 -- CSV名 ) IS /* --一、创 阅读全文