Advertisement
Guest User

Untitled

a guest
Aug 10th, 2018
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import cx_Oracle
  2. dsnStr=cx_Oracle.makedsn("helppls.pl.phub.com","2137","gang")
  3. con=cx_Oracle.connect(user='niewiem', password='comamzrobic', dsn=dsnStr)
  4. cur=con.cursor()
  5.  
  6. cur.execute("""SELECT DISTINCT M_STATUS, STOER_TEXT
  7. FROM HYDADM.MASCHINEN_STATUS INNER JOIN
  8. (HYDADM.STOER_TABELLE INNER JOIN HYDADM.STOERTEXTE ON HYDADM.STOER_TABELLE.STOERTXT_NR = HYDADM.STOERTEXTE.STOERTXT_NR)
  9. ON HYDADM.MASCHINEN_STATUS.M_STATUS = HYDADM.STOER_TABELLE.STOERNR
  10. WHERE HYDADM.MASCHINEN_STATUS.MASCH_NR = :id""",{'id': 603501})
  11.  
  12.  
  13. for line in cur:
  14. print(line)
  15.  
  16. cstat(603501)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement