python操作oracle视频教程,Python 操作oracle

Python使用cx_Oracle模块可以连接并操作oracle数据库，下面给出具体方法，仅供参考

#coding=utf-8

import cx_Oracle

db_connect_info = "scott/tiger@192.168.7.170:1521/orcl"

db_base_table = "test01"

#连接数据库

db_conn = cx_Oracle.connect(db_connect_info)cursor = db_conn.cursor()

#获取表定义

get_base_table_stru = "SELECT DBMS_METADATA.GET_DDL('TABLE','" + db_base_table.upper() + "') FROM DUAL"

cursor.execute(get_base_table_stru)

db_base_table_content = cursor.fetchall()

for row in db_base_table_content:

db_base_table_ddl = str(row[0])

print db_base_table_ddl

#获取表中记录数

db_get_table_count_dql = "SELECT COUNT(*) FROM " + db_base_table

try:

cursor.execute(db_get_table_count_dql)

db_get_table_count_list = cursor.fetchall()

for row in db_get_table_count_list:

db_get_table_count = row[0]

print db_get_table_count

except:

print "cx_Oracle.DatabaseError:ORA-00942 表或视图不存在"

db_close(db_conn,cursor)

sys.exit(1)

#获取表中类型

db_get_max_table_column_name_types_dql = "SELECT COLUMN_NAME,DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME = '" + db_base_table.upper() + "'"

cursor.execute(db_get_max_table_column_name_types_dql)

db_max_table_column_name_types = cursor.fetchall()

for column_name,data_type in db_max_table_column_name_types:

print "column_name = ",column_name

print "data_type = ",data_type

#断开数据库连接

cursor.close()

db_conn.close()