如何替换'?‘在cx_Oracle查询中使用所提供的值

import cx_Oracle

# 创建连接
connection = cx_Oracle.connect("username", "password", "host:port/service_name")

# 创建游标
cursor = connection.cursor()

# 编写SQL查询语句
sql = "SELECT * FROM table_name WHERE column_name = :value"

# 执行查询
cursor.execute(sql, value="some_value")

# 获取查询结果
result = cursor.fetchall()

import cx_Oracle

# 创建连接
connection = cx_Oracle.connect("username", "password", "host:port/service_name")

# 创建游标
cursor = connection.cursor()

# 编写SQL查询语句
sql = "SELECT * FROM table_name WHERE column_name = :value"

# 执行查询
cursor.execute(sql, value="some_value")

# 获取查询结果
result = cursor.fetchall()

# 关闭游标和连接
cursor.close()
connection.close()