摘要:
CREATE OR REPLACE TRIGGER update_rolejurisdictionAFTER UPDATE ON zxauthen.zx0103FOR EACH ROWBEGIN update t_xzzf_rolejurisdiction t set t.rolecode = :N 阅读全文
摘要:
select * from T_YZTB_XZFXK_FJSC_INFO as of TIMESTAMP TO_TIMESTAMP('2023-10-08 09:00:00','YYYY-MM-DD HH24:MI:SS'); FLASHBACK T_YZTB_SPJYXK_WTDLR_INFO a 阅读全文
摘要:
ALTER TABLE table_name RENAME TO new_table_name --新增表字段和注释 ALTER TABLE ZX_XZZF_AJJBQK ADD SFTSZJ VARCHAR2(20); COMMENT ON COLUMN ZX_XZZF_AJJBQK.SFTSZJ 阅读全文
摘要:
--1、查看大小和路径:查询该用户下的默认临时表空间 SELECT bytes/1024/1024/1024 AS "大小(G)",NAME FROM v$tempfile ORDER BY bytes;--2、创建新的临时表空间create temporary tablespace temp02 阅读全文