不说废话,贴代码: CREATE OR REPLACE FUNCTION to_time(sec IN NUMBER) RETURN VARCHAR2 IS /*把秒转成时分秒格式 auth lzpong 201/09/16 */ BEGIN ))), ,); EXCEPTION WHEN OTHERS THEN RETURN '0:00:00'; END to_time; CREATE OR REPLACE FUNCTION isnumeric(str IN VARCHAR2) RETURN
python3判断字符串内是否含有字母,并打印字母出来 # !/usr/bin/python3.4 # -*- coding: utf-8 -*- import re a = "8a2656" b = "1514561A1321" c = "15465461654" d = "afgwgw" r = re.compile(r'^[a-zA-Z]') for item in d: result = r.match(item) i
for index,value in enumerate(listvalue): adchar=chardet.detect(value) print adchar if adchar['encoding']=='utf-8' or adchar['encoding']=='ascii': code='utf-8' else: code='GBK' value=value.decode(code)#解码生成unicode编码