在配置python環(huán)境，并安裝所需包后，運(yùn)行下列代碼~

            
              
                import
              
               pandas 
              
                as
              
               pd  

              
                from
              
               sqlalchemy 
              
                import
              
               create_engine  

              
                import
              
               cx_Oracle


              
                #進(jìn)行oracle服務(wù)器設(shè)置，用戶名；密碼；HOST數(shù)據(jù)庫(kù)IP地址；PORT端口號(hào)；SERVICE_NAME
              
              
db
              
                =
              
              cx_Oracle
              
                .
              
              connect
              
                (
              
              
                'userid'
              
              
                ,
              
              
                'password'
              
              
                ,
              
              
                '10.10.1.10:1521/dbinstance'
              
              
                )
              
              
                print
              
              
                (
              
              db
              
                .
              
              version
              
                )
              
                

cr
              
                =
              
              db
              
                .
              
              cursor
              
                (
              
              
                )
              
              
                #插入所需sql語(yǔ)句
              
              
sql
              
                =
              
              
                'select * from sys_user'
              
                
cr
              
                .
              
              execute
              
                (
              
              sql
              
                )
              
                
rs
              
                =
              
              cr
              
                .
              
              fetchall
              
                (
              
              
                )
              
                
zz
              
                =
              
              pd
              
                .
              
              DataFrame
              
                (
              
              rs
              
                )
              
              
                ;
              
              
                print
              
              
                (
              
              zz
              
                )
              
                

db
              
                .
              
              close
              
                (
              
              
                )
              
            
          

參考：
python鏈接oracle數(shù)據(jù)庫(kù)以及數(shù)據(jù)庫(kù)的增刪改查
Python連接Oracle