安装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
阅读(428)
推荐(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
阅读(89)
推荐(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
阅读(77)
推荐(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
阅读(216)
推荐(0) 编辑
