数据仓库服务 GAUSSDB(DWS)-数学函数:声明Hexadecimal Binary Literal值

时间:2024-12-10 11:28:48

声明Hexadecimal Binary Literal值

输入:

CREATE MULTISET TABLE bvalues (IDVal INTEGER, CodeVal BYTE(2));
INSERT INTO bvalues VALUES (112193, '7879'XB) ;
SELECT IDVal, CodeVal FROM bvalues WHERE CodeVal = '7879'XB ; 

输出

support.huaweicloud.com/tg-dws/dws_16_0044.html