一、將Oracle中的某張表導(dǎo)出到csv文件

import cx_Oracle
import pandas as pd

conn = cx_Oracle.connect('username', 'password', '127.0.0.1:1521/TESTDB')
sql = 'SELECT * FROM student'
df = pd.read_sql(sql, conn)
df.to_csv('student.csv')
print(df.head())

二、獲得自身進(jìn)程號(hào)并殺掉自身進(jìn)程

import os
import time

# 獲得當(dāng)前進(jìn)程號(hào)
pid = os.getpid()
print('pid:', pid)

for i in range(100):
    print(i)
    time.sleep(0.5)
    if i == 11:
        # 結(jié)束當(dāng)前進(jìn)程
        os.system('kill -9 {}'.format(pid))