1、clob中存储的内容为xls文件,按照二进制读取之后,通过base64编码存储的记录
content字段为clob类型
import cx_Oracle
import base64
# 连接数据库
conn = cx_Oracle.connect('user/password@127.0.0.11:1521/orcl')
# 查询包含BLOB字段的表,并获取BLOB字段的引用
cursor = conn.cursor()
cursor.execute("select CONTENT from table1 where EID ='EXEC-111111'")
blob1= cursor.fetchone()[0]
blob12 = base64.b64decode(str(blob1))
# 获取文件路径
file_path = r'D:\file.xls'
# 打开文件并写入BLOB内容
with open(file_path, 'wb') as file:
file.write(blob12)
# 关闭数据库连接
conn.close()