---学习函数translate及instr---
--- instr(要被检索的字符串，要匹配查找的字符串,查找的超始位置,出现次数) 返回结果为0或字符位置
SQL> select substr('/zxy/abc/sex/file.txt',instr('/zxy/abc/sex/file.txt','/',-1,1)+1) from dual;--提取完整文件路径的文件名字

SUBSTR('
--------
file.txt

SQL> select translate('abcde','ab','12') from dual;---translate(源字符串，要被替换的字符串，替换的目标字符串，是a变成1,b变成2

TRANS
-----
12cde

SQL> r
1 declare
2 x integer;
3 y integer:=10;
4 begin
5 x:=2;
6 x:=power(x,y);
7 dbms_output.put_line(to_char(x));
8* end;
1024

PL/SQL procedure successfully completed.

SQL>

SQL> r --用dbms_random.seed|value生成10个随机数
1 declare
2 n number;
3 begin
4 dbms_random.seed(123456);
5 for i in 1..10 loop
6 n:=dbms_random.value;
7 dbms_output.put_line(n);
8 end loop;
9* end;
.92531681298113309873787795771931592618
.37030598670766388947177774255021367313
.85627876026627488798969838605307783671
.87477697910153471636774762100980896094
.85388878942835050010332218162337016388
.01397624210289665573989184662255006214
.67898277688857989692025248634278427432
.12197581976051255294858781152477067881
.63848618812986540421626125487210386332
.50604155277751856355227790589643001614

PL/SQL procedure successfully completed.

SQL>

ITPub博客

plsql_function_package_translate_instr_dbms_random测试小记

最新文章