목록insertDB (1)

무회blog

python:200526-pyDB-001.003, insert, 단건(oracle)

# DB-003, python DB insert import pandas as pd import cx_Oracle import time # conn=cx_Oracle.connect("scott/tiger@192.168.182.1:1521/xe") # def save_data(): db = conn=cx_Oracle.connect("scott/tiger@192.168.182.1:1521/xe") try: cr = db.cursor() except: print('database connection faile') # # insert into emp( # EMPNO =7500 # ENAME ='ALLEN' # JOB ='SALESMAN' # MGR =7698 # HIREDATE ='SYSDATE' # SAL =..
Python 2020. 5. 25. 20:10
Prev 1 Next