[Python]Oracle 접속

 

import cx_Oracle
 
con = cx_Oracle.connect('아이디/암호@아이피:1521/인스턴스명')
 
cur = con.cursor()
 
cur.execute('Query문')
 
for result in cur:
 
  print(result)
 
cur.close()
 
con.close()
 

 

 

Colored By Color Scripter™

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

--모든 테이블 조회 SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABLE' --컬럼 목록 조회 SELECT * FROM COLS WHERE TABLE_NAME = '테이블명' SELECT *  FROM T_LOGIN_LOG SELECT *  FROM COLS where TABLE_NAME = 'T_LOGIN_LOG' SELECT *  FROM ALL_OBJECTS where OBJECT_TYPE = 'TABLE'