GBASE南大通用GBase 8s数据库常用函数-其它函数

最新推荐文章于 2024-09-17 13:42:29 发布

GBASE数据库

最新推荐文章于 2024-09-17 13:42:29 发布

阅读量424

点赞数 10

文章标签：数据库 sql GBASE南大通用 GBASE

本文链接：https://blog.csdn.net/weixin_47390342/article/details/136256880

版权

GBASE南大通用分享：GBase 8s数据库常用函数

其它函数

DBINFO

select dbinfo('dbhostname') as f_hostname from dual;
select dbinfo('dbname') as f_dbname from dual;
select dbinfo('version', 'full') as f_version from dual;
select dbinfo('sessionid') as f_sessionid from dual;
select dbinfo('bigserial') as f_bigserial from dual;
select dbinfo('serial8') as f_serial8 from dual;

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

f_hostname 

devsvr

1 row(s) retrieved.

> select dbinfo('dbname') as f_dbname from dual;


f_dbname  mydb

1 row(s) retrieved.

> select dbinfo('version', 'full') as f_version from dual;


f_version                          

GBase Server Version 12.10.FC4G1TL

1 row(s) retrieved.

> select dbinfo('sessionid') as f_sessionid from dual;

f_sessionid 

         23

1 row(s) retrieved.

> select dbinfo('bigserial') as f_bigserial from dual;

         f_bigserial 

                   0

1 row(s) retrieved.

> select dbinfo('serial8') as f_serial8 from dual;

           f_serial8 

                   0

1 row(s) retrieved.

>

GBASE南大通用分享：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;

> 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;

f_username f_leavedate f_userstatus 

Tom        2020-06-18  离职
Jim                    在职

2 row(s) retrieved.

>

GBASE南大通用分享：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;

> 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;

f_hex1  0x000000FF
f_hex2  0x0000FFFF
f_hex3  0x0000000080808080
f_hex4  0x0000000100000000
f_hex5  0x0fffffffffffffff

1 row(s) retrieved.

>

GBASE南大通用分享：GetHzFullPY

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

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

f_py  nandatongyong 

1 row(s) retrieved.

>

SYS_GUID

> select sys_guid() from dual;

(expression)                     

6FAE9FAC458A4B52AC7DCA22A2D19D6F

1 row(s) retrieved.

>

select current,dbservername,rowid,sitename,sysdate,today,current_user,user from dual;

> select current,dbservername,rowid,sitename,sysdate,today,current_user,user from dual;

(expression)  2021-06-26 00:53:24.041
(expression)  gbaseserver
rowid         769
(expression)  gbaseserver
(expression)  2021-06-26 00:53:24.04174
(expression)  2021 06月 26日
(expression)  gbasedbt
(expression)  gbasedbt

1 row(s) retrieved.

>