Gbase 8s内置函数之其它函数

Gbase 8s的内置函数包含标量函数、聚合函数、窗口函数以及其他的函数。

本次介绍其它函数及其使用例句:

DBINFO

select dbinfo('dbhostname') as f_hostname from dual;

NVL2

select f_username, f_leavedate, nvl2(f_leavedate, '离职', '在职') as f_userstatus

from

(select 'Tom' as f_username, '2020-06-18' as f_leavedate from dual

union all

select 'Jim' as f_username, null as f_leavedate from dual) t;

HEX

select hex(255) as f_hex1, hex(65535) as f_hex2, hex(2155905152) as f_hex3, hex(4294967296) as f_hex4, hex(1152921504606846975) as f_hex5 from dual;

GetHzFullPY

select GetHzFullPY('南大通用') as f_py from dual;