函数分类oraclehiveupper（'coolszy'）upper(string A)ucase(string A)lower（'KUKA'）lower(string A)lcase(string A)initcap('kuKA aBc')无concat（'Hello','world'）concat(string A, string B„)substr（'hello',2,3）substr(string A, int start,int len) substring(stringlength（'hello'）length(string A)lpad（‘smith’,10,'*'）lpad(string str, int len,string pad)rpad(‘smith’,10,'*')rpad(string str, int len,string pad)trim(' Mr Simth ')trim(string A)ltrim(' Mr Simth ')ltrim(string A)rtrim(' Mr Simth ')rtrim(string A)reverse（‘abcdef’） reverse(string A)replace('HELLO','L','x')regexp_replace(string A,string B, string C)ascii('A')ascii(string str)chr(54740)无无concat_ws(string SEP,string A, string B„)无parse_url(string urlString,string partToExtract [,无space(int n)无repeat(string str, int n)无split(string str, stringpat)无regexp_extract(stringsubject, string pattern,无sentences(string str,string lang, string locale)无e()无pi()instr('oracletraning','ra',1,2)find_in_set(string str,string strList)无get_json_object(stringjson_string, string path)round(double a)round(double a)trunc(412.23,2)无abs(-100)abs(double a)字符函数asin(0.5)asin(double a)acos(-1)acos(double a)ceil(3.1415927) ceil(3.1415927)sin(20)sin(double a)cos(-3.1415927)cos(double a)sqrt(64)sqrt(double a)exp(2)exp(double a)floor(2345.67)floor(double a)无rand(),rand(int seed)ln(2.7182818)ln(double a)LOG(n1,n2)log(double base, doublea)power(2,10)pow(double a, double p)power(double a, double p)ROUND和TRUNCround(doublea)round(double a, int d)SIGNsign(double a)tan(20)tan(double a)atan(1)atan(1)无conv(BIGINT num, intfrom_base, int to_base)无positive(int a)positive(double a)无negative(int a)negative(double a)mod(int a, int b)mod(double a, doublepmod(int a, int b)pmod(double a, double b)sysdate无months_between(sysdate,'16-6月 -09')无add_months(sysdate,4)无TO_DATE(string,'format')无TO_CHAR(date,'format')无next_day(sysd...
