import cx_Oracle
conn = cx_Oracle.connect(‘账号/密码@IP:Port/数据库名’)
curs = conn.cursor()
sql = 'select * from 表名 缩写 where 缩写.项目=‘字符串’ ’
curs.execute(sql)
for result in curs:
print(result)
curs.close()
conn.close()
import cx_Oracle
conn = cx_Oracle.connect(‘账号/密码@IP:Port/数据库名’)
curs = conn.cursor()
sql = 'select * from 表名 缩写 where 缩写.项目=‘字符串’ ’
curs.execute(sql)
for result in curs:
print(result)
curs.close()
conn.close()