08 2024 档案

oracle开发
摘要：1.查看事务id select xid from v$transaction; 2.查看当前scn值 select current_scn from v$database; select dbms_flashback.get_system_change_number from dual; 3.查看锁 阅读全文
posted @ 2024-08-29 10:21 TryMyBest! 阅读(4) 评论(0) 推荐(0) 编辑
oracle异常捕捉及处理
摘要：1、 declare e_emps_remaining exception; pragma exception_init(e_emps_remaining,-2292);begin delete from dept where deptno=20; exception when e_emps_rem 阅读全文
posted @ 2024-08-07 20:01 TryMyBest! 阅读(21) 评论(0) 推荐(0) 编辑
oracle的plsql
摘要：显示打印结果set serverout on; 1、 declare v_ename scott.emp1.ename%type;v_emp1 scott.emp1%rowtype;begin select ename into v_ename from emp1 where empno=7788; 阅读全文
posted @ 2024-08-01 17:02 TryMyBest! 阅读(9) 评论(0) 推荐(0) 编辑