青彦的博客

人大金仓集群停止服务时，一台停止失败，一台停止成功telnet ip 8890如果提示 connect to address ip connection refused删除Server/bin下的 es_seever.pid，在Server/bin/下 执行 ./esHAmodel.sh starttelnet ip 8890如提示Trying ipConnected to i...

kingbasecreate function substring_index(f_string in text, f_delimiter in varchar2, f_position in number) return textas o_string text; v_direction int; v_instr_pos int;begin IF f_position = 0 THEN RETURN ''; END IF; if f_position > 0

CREATE OR REPLACE FUNCTION FIND_IN_SET (piv_str1 VARCHAR2,piv_str2 VARCHAR2,p_sep VARCHAR2 := ‘,’) RETURNS NUMBERASDECLAREl_idx NUMBER := 0;str VARCHAR2(500);piv_str VARCHAR2(500) := piv_str2;res NUMBER := 0;loopIndex NUMBER := 0;BEGINIF instr

Sql :SELECTcount( 0 )FROM(SELECTid_ AS ‘id’,user_id_ AS ‘userId’,user_name_ AS ‘userName’,org_id_ AS ‘orgId’,org_name_ AS ‘orgName’,clock_time_ AS ‘clockTime’,clock_type_ AS ‘clockType’FROMsys_clock_inWHERETO_DAYS( clock_time_ ) = TO_DAYS(