05 2021 档案
安装sap license
摘要:命令:saplikey saplikey -help SAP License Key Administration - Copyright (C) 2003 - 2016 SAP AG usage: saplikey pf=<profile> [trace=<level>] <command> wh 阅读全文
posted @ 2021-05-27 17:01 InnoLeo 阅读(486) 评论(0) 推荐(0)
oracle dbms_random
摘要:1.dbms_random.random return equal to -power(2,31) and less than power(2,31) SQL> select abs(dbms_random.random ) from dual; ABS(DBMS_RANDOM.RANDOM) 11 阅读全文
posted @ 2021-05-12 15:42 InnoLeo 阅读(108) 评论(0) 推荐(0)
oracle row/column
摘要:LISTLAG LISTAGG function SyntaxAggregate Syntax: LISTAGG(measure_expr [, 'delimiter']) WITHIN GROUP (order_by_clause) Analytic Syntax : LISTAGG(measur 阅读全文
posted @ 2021-05-06 23:51 InnoLeo 阅读(96) 评论(0) 推荐(0)
oracle 树形查询,自连接查询
摘要:例1 select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id 1 Steven King 阅读全文
posted @ 2021-05-06 23:33 InnoLeo 阅读(230) 评论(0) 推荐(0)