定义 type arrays is varray(1000) of number; v_contract_id_list arrays; 查询 SELECT ... BULK COLLECT INTO... FROM...

create public database link DB_L connect to DB_DATA identified by DB_L using '(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.x.x)(PORT=1521)) ) (CONNECT_DATA…

以下几个为相关表 SELECT FROM v$lock; SELECT FROM v$sqlarea; SELECT FROM v$session; SELECT FROM v$process ; SELECT FROM v$locked_object; SELECT FROM all_objects; SELECT * FROM v$sessio…

启动数据库实例，分为两步：第一步，启动监听；第二步，启动数据库实例。 一、如何启动数据库实例 进入到sqlplus启动实例 --“切换到oracle用户” su - oracle --“打开监听” lsnrctl start --“进入到sqlplus” sqlplus /nolog --“连接到sysdba” conn /as sysdba --…

select * from user_source a where lower(text) like '%create_acp_invoice_je%'

xxl-job 初始化创建表代码 # # XXL-JOB v2.2.1-SNAPSHOT # Copyright (c) 2015-present, xuxueli. CREATE database if NOT EXISTS `xxl_job` default character set utf8mb4 collate utf8mb4_unico…

CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000); CREATE OR REPLACE FUNCTION fn_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN ty_str_split IS j INT …

1.查看所有用户： select * from dba_users; select * from all_users; select * from user_users; 2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限)： select * from dba_sys_privs; select * from user_sys_privs…