wanggeying

--1、创建表create table userinfo(id number(10,0) primary key,       name varchar2(40));--2、创建序列create sequence userinfo_seq start with 1 maxvalue 9999999999 increment by 1;--3、创建触发

/** dblink 创建create database link GJDB  connect to BDCDJ  using '192.168.0.5/ORCL';*//** 创建自动增长序列： create sequence autoId increment by 1 start with 1 maxvalue 999999 cycle;    cr

模糊查询：连接符:  ||  示例： select org_id  into getorgid from kq_org_persons where person_id like newId||'%' and org_type='DEPARTMENT'; 基础了解：trigger和procedure,function类似,只不过它不能被显示调用,只能被某个事件

trigger调用外部java文件过程

问题如图：解决方案：1、备份触发器2、更改触发器，可直接复制以下内容使用：CREATE OR REPLACE TRIGGER "DB_EV_ALTER_ST_METADATA" AFTER DROP ON DATABASE BEGIN IF  (ora_dict_obj_type = 'TABLE') THEN DELETE FROM sde3.st_geometry_co...