Python连接teradata和Oracle的简单例子

参考文档：http://developer.teradata.com/tools/reference/teradata-python-module

#!/usr/bin/python

# encoding=utf-8

#连接Teradata

import teradata
import cx_Oracle  
udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0",logConsole=False)
session = udaExec.connect(method="odbc", system="192.168.1.175",username="dbc", password="dbc");
for row in session.execute("SEL * FROM DBC.TABLES"):
     print(row)
     print(row[0] + ": " + row[1])
     print(row["tableName"])
     print(row.name + ": " + row.val)


#连接orcle数据库
conn = cx_Oracle.connect('hr/hr@localhost/orcl')    
cursor = conn.cursor ()  
cursor.execute ("DROP TABLE TEST")    
cursor.execute ("CREATE TABLE TEST(ID INT, COL1 VARCHAR(32), COL2 VARCHAR(32), COL3 VARCHAR(32))")  
cursor.execute ("INSERT INTO TEST (ID, COL1, COL2, COL3)VALUES(1, 'a', 'b', 'c')")  
cursor.execute ("INSERT INTO TEST (ID, COL1, COL2, COL3)VALUES(2, 'aa', 'bb', 'cc')")  
cursor.execute ("INSERT INTO TEST (ID, COL1, COL2, COL3)VALUES(3, 'aaa', 'bbb', 'ccc')")  
conn.commit()  
cursor.close ()  
conn.close ()

最后

以上就是壮观太阳最近收集整理的关于Python连接teradata和Oracle的简单例子的全部内容，更多相关Python连接teradata和Oracle内容请搜索靠谱客的其他文章。