목록executemany (2)

무회blog

python:200526-pyDB_ver001.02, - insert 다건 , executemany()

from excel to oracle table dbcode 01 CREATE TABLE "PYTEST001"."VITA5" ("GN_NM" VARCHAR2(20 BYTE) NOT NULL ENABLE, "GN_MEMO" VARCHAR2(20 BYTE) NOT NULL ENABLE, "GN_EVALUATION" VARCHAR2(4000 BYTE), "GN_CONTENT" VARCHAR2(4000 BYTE), "GN_DATE" DATE, "GN_EVALUATIONCOUNT" NUMBER(5,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEX..
Python 2020. 5. 26. 16:31
python:200526-pyDB_ver001.01, insert 단건, 다건 , oracle 기준

oracle DB 코드 --select sysdate from dual; --EXEC dbms_xdb.sethttpport(9090); --SELECT dbms_xdb.gethttpport() FROM DUAL; --alter table VITA5 modify(GN_EVALUATION varchar2(4000)); --alter table VITA5 modify(GN_CONTENT varchar2(4000)); --COMMIT; --select a.sid, a.serial# from v$session a, v$lock b, dba_objects c --where a.sid=b.sid and b.id1=c.object_id and b.type='TM' and c.object_name='VITA5'; --A..
DB 2020. 5. 26. 15:37
Prev 1 Next