摘要: set serveroutput on set linesize 1000 set pages 0 declare total_line_number number; dop number; skip number; load number; tail_of_mod number; command 阅读全文
posted @ 2023-05-17 17:58 diablo-427 阅读(5) 评论(0) 推荐(0) 编辑
摘要: select CASE WHEN ASCIISTR(name) LIKE '%\%' AND LENGTH(name) = 2 THEN '*' || SUBSTR(name, -1) --脱敏姓名中文2个汉字 WHEN ASCIISTR(name) LIKE '%\%' AND LENGTH(na 阅读全文
posted @ 2023-03-07 14:42 diablo-427 阅读(16) 评论(0) 推荐(0) 编辑
摘要: --generalFUNCTION MGRNAME(P_EMPNO IN EMP.EMPNO%TYPE) RETURN EMP.ENAME%TYPE IS RESULT EMP.ENAME%TYPE; I INTEGER; BEGIN RESULT := NULL; I := 1; IF P_EMP 阅读全文
posted @ 2023-03-02 14:52 diablo-427 阅读(197) 评论(0) 推荐(0) 编辑
摘要: SELECT LENGTH(''),LENGTH(NULL),LENGTH(' '),LENGTH(TRIM(' ')) FROM dual; 返回结果为 null,null,1,null 也就是在oracle中null和''等价,不能用length('')或者length(null)来判断空值 o 阅读全文
posted @ 2023-01-12 10:56 diablo-427 阅读(287) 评论(0) 推荐(0) 编辑
摘要: #!/bin/bash ##file_name _transfer_name=/home/zcx/test/ target_file=all.txt echo "startng..........................." if [ -e "$target_file" ]; then `r 阅读全文
posted @ 2023-01-02 22:06 diablo-427 阅读(78) 评论(0) 推荐(0) 编辑
摘要: def binarysearch(_list,value): left = 0 right = len(_list) mid = int((left+right)/2) while (left<right): if value ==_list[mid]: return mid elif value< 阅读全文
posted @ 2022-11-29 17:38 diablo-427 阅读(16) 评论(0) 推荐(0) 编辑
摘要: `#随机数 import random red = range(1,36,1) red_target_list=[] i=1 while i< 6: red_ran_index=random.randint(0,34) #0-34 red_target_list_value=red[red_ran_ 阅读全文
posted @ 2022-11-29 17:36 diablo-427 阅读(34) 评论(0) 推荐(0) 编辑
摘要: select * from test_all; --全量的数据 insert into test_all (ID, NAME, FISRT_FLG) values ('1', 'aaa', '1'); insert into test_all (ID, NAME, FISRT_FLG) values 阅读全文
posted @ 2022-10-16 23:49 diablo-427 阅读(28) 评论(0) 推荐(0) 编辑
摘要: Good morning, everyone. Thank you for taking your time. It’s really my honor to have this opportunity to take part in this interview. Now, I would lik 阅读全文
posted @ 2022-10-09 15:48 diablo-427 阅读(25) 评论(0) 推荐(0) 编辑
摘要: Good morning, ladies and gentlemen It is my great honor to have this opportunity to introduce myself. And I hope I could make a good performance today 阅读全文
posted @ 2022-10-09 15:35 diablo-427 阅读(20) 评论(0) 推荐(0) 编辑