上一页 1 ··· 9 10 11 12 13 14 下一页
摘要: --插入时不产生日志, --alter table cux_mtl_material_vmi2024038 nologging; --记录时间 --set timing on; declare cursor cur is select mmt.organization_id, mmt.subinve 阅读全文
posted @ 2024-03-18 21:39 Iven_lin 阅读(56) 评论(0) 推荐(0)
摘要: CREATE OR REPLACE PACKAGE PKG_ETL_CTL IS -- 调用主程序,调用存储过程 PROCEDURE SP_EXEC_PROC(I_JOB_ID NUMBER); -- 创建新的时间周期,运行数据周期作业及作业流状态处理 PROCEDURE SP_FLOW_RUN_D 阅读全文
posted @ 2023-01-19 13:58 Iven_lin 阅读(87) 评论(0) 推荐(0)
摘要: DEMO declare type tsi is record( t varchar2(100), s varchar2(100), i varchar2(100)); tsitemp tsi; maxid varchar2(20); begin for tsitemp in (select 'T_ 阅读全文
posted @ 2023-01-19 13:54 Iven_lin 阅读(30) 评论(0) 推荐(0)
摘要: select * from li.books where book_publish_date between '1-2月-2005' and '1-2月-2010'; select * from books where book_price between 50 and 60; select * f 阅读全文
posted @ 2023-01-19 13:53 Iven_lin 阅读(53) 评论(0) 推荐(0)
摘要: --创建表 create table tb_rent( region varchar2(2000), room varchar2(2000), hall varchar2(2000), rent varchar2(2000) ) 创建存储过程 create or replace procedure 阅读全文
posted @ 2023-01-19 13:52 Iven_lin 阅读(481) 评论(0) 推荐(0)
摘要: SELECT l.session_id sid, s.serial#, l.locked_mode 锁模式, l.oracle_username 登录用户, l.os_user_name 登录机器用户名, s.machine 机器名, s.terminal 终端用户名, o.object_name 阅读全文
posted @ 2023-01-19 13:50 Iven_lin 阅读(35) 评论(0) 推荐(0)
摘要: DEMO 阶段3 declare v_dept dept%rowtype; begin v_dept.deptno := &deptno; V_dept.dname := '&deptname'; V_dept.loc := '&loc'; if instr(v_dept.dname, ' ') > 阅读全文
posted @ 2023-01-19 13:46 Iven_lin 阅读(18) 评论(0) 推荐(0)
摘要: 需要sys账户登录后 SELECT * FROM SYS.link$; 阅读全文
posted @ 2023-01-19 13:45 Iven_lin 阅读(344) 评论(0) 推荐(0)
摘要: -- 库存MTASELECT c.code_combination_id, c.segment1, c.segment2, c.segment3, c.segment4, c.segment5, h.currency_code, h.period_name, to_number(to_char(h. 阅读全文
posted @ 2023-01-19 13:43 Iven_lin 阅读(30) 评论(0) 推荐(0)
摘要: SELECT ICON_NAME, ROW_ID, USER_CONCURRENT_PROGRAM_NAME, ENABLED_FLAG, CONCURRENT_PROGRAM_NAME, DESCRIPTION, EXECUTION_OPTIONS, REQUEST_PRIORITY, INCRE 阅读全文
posted @ 2023-01-19 13:41 Iven_lin 阅读(28) 评论(0) 推荐(0)
上一页 1 ··· 9 10 11 12 13 14 下一页