摘要:
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 阅读全文
摘要:
select CASE WHEN ASCIISTR(name) LIKE '%\%' AND LENGTH(name) = 2 THEN '*' || SUBSTR(name, -1) --脱敏姓名中文2个汉字 WHEN ASCIISTR(name) LIKE '%\%' AND LENGTH(na 阅读全文
摘要:
--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 阅读全文
摘要:
SELECT LENGTH(''),LENGTH(NULL),LENGTH(' '),LENGTH(TRIM(' ')) FROM dual; 返回结果为 null,null,1,null 也就是在oracle中null和''等价,不能用length('')或者length(null)来判断空值 o 阅读全文
摘要:
#!/bin/bash ##file_name _transfer_name=/home/zcx/test/ target_file=all.txt echo "startng..........................." if [ -e "$target_file" ]; then `r 阅读全文
摘要:
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< 阅读全文
摘要:
`#随机数 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_ 阅读全文
摘要:
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 阅读全文
摘要:
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 阅读全文
摘要:
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 阅读全文