Files

11 lines
334 B
Python

import oracledb
try:
conn = oracledb.connect(user='sisvietnam', password='sisvietnam', dsn='localhost:1521/sisvietnam')
cursor = conn.cursor()
cursor.execute("SELECT COUNT(*) FROM sis_doctor")
print(f"Doctors in Oracle: {cursor.fetchone()[0]}")
conn.close()
except Exception as e:
print(f"Oracle error: {e}")