import cx_Oracle

conn = cx_Oracle.connect('glyh_crm2/glyh_crm2@200.100.51.73:1521/ZXYH')

def getTableFields(tableName):
    sql = "select t.COLUMN_NAME from user_tab_columns t  where t.table_name='%s'" % (tableName)
    c = conn.cursor()
    rst = c.execute(sql)
    fields = map(lambda x: x[0], rst.fetchall())
    fields = list(fields)

    if fields.count('UPDATE_DATE')==0:
        sql = 'alter table %s add (UPDATE_DATE char(8) null)' % (tableName)
        c.execute(sql)
        conn.commit()

    c.close()

conn.close()