import os, time
import datetime
import cx_Oracle

dirs = 'C:/Users/Documents/new'
dir_collection = []
dt = datetime.datetime.now()
delta = datetime.timedelta(hours=12)

for dirpath, dirnames, filenames in os.walk(dirs):
    FileDate = os.path.getctime(dirpath)
    FileDate = datetime.datetime.fromtimestamp(FileDate)
    delta_file = dt - FileDate
    if delta_file > delta :
        dir_collection.append(filenames)

     

con = cx_Oracle.connect('user/password@127.0.0.1/mybase')
cur = con.cursor()
for i in dir_collection:
    example = [i, datetime.datetime.now()]
cur.executemany (
    "insert into table(NAME_FILE, sys_creation_date) values (:1, :2)"
    , example)
con.commit()
cur.close()
con.close()

full = os.listdir(dirs)
for filenames in full:
    fullname = os.path.join(dirs, filenames)
    FileDate = os.path.getctime(fullname)
    FileDate = datetime.datetime.fromtimestamp(FileDate)
    delta_file = dt - FileDate
    if delta_file > delta :
        dir_collection.append(filenames)