该sql语句可以查出某些没有自动弹出的错误
SELECT * FROM USER_ERRORS WHERE NAME = '包名';
该sql语句可以导出包
select dbms_metadata.get_ddl('PACKAGE', '包名') from dual;
create sequence t_r_workbench_city_CITYID
minvalue 1
maxvalue 99999999999999999999
start with 1
increment by 1
cache 20
cycle;
t_r_workbench_city_CITYID --序列名(自增)
t_r_workbench_city_trigger --触发器名
T_R_WORKBENCH_CITY --表名(大小写严格)
t_r_workbench_city."CITYID" --表中的主键
create or replace trigger t_r_workbench_city_trigger
before insert on "T_R_WORKBENCH_CITY" for each row
begin
select t_r_workbench_city_CITYID into :t_r_workbench_city."CITYID" from dual;
end;
我要在oracle数据库的现有记录上,生成唯一标识符
CREATE SEQUENCE seq_name1
START WITH 1
INCREMENT BY 1;
表上添加一个新的列
UPDATE tmpd_special_supervise_0823_02 t
SET t.rid = seq_name1.NEXTVAL;
检查
SELECT * FROM tmpd_special_supervise_0823_02 t;
select count(t.rid) from tmpd_special_supervise_0823_02 t ;
--数值相等
完成
oracle数据库导入excel文件
链接: 利用PL/SQL Developer工具导入excel数据