diablo-427

摘要： 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 閱讀全文