Oracle某些功能实现语句处理方法

触发器以及序列
CREATE OR REPLACE TRIGGER t_MSTB_BDS_DATA BEFORE INSERT ON  MSTB_BDS_DATA  FOR EACH ROW
DECLARE
  INTEGRITY_ERROR  EXCEPTION;
    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN

 SELECT SEQ_MSTB_BDS_DATA.NEXTVAL INTO :NEW.data_id FROM DUAL;

--  ERRORS HANDLING
EXCEPTION
    WHEN INTEGRITY_ERROR THEN
       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);

END ;


create sequence SEQ_MSTB_BDS_DATA
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 21;

插入HTML格式语句实现方法

某字段存数据为以下格式：<input type=‘radio‘  name=‘ids‘  value=‘$0‘/>
insert into MSTB_BDS_DATA (DATA_ID, NAME_TC ) values(‘16‘, ‘<input type=‘||‘‘‘radio‘‘  name=‘||‘‘‘ids‘‘  value=‘||‘‘‘$0‘‘/>‘)

格式为这样的<img src=‘afw/common/images/table/basic_blue/filter.gif‘/>

实现如下：
insert into MSTB_BDS_DATA ( NAME_TC) values(‘<img src=‘||‘‘‘afw/common/images/table/basic_blue/filter.gif‘‘/>‘);
insert into MSTB_BDS_DATA ( NAME_TC) values(‘<textarea cols=‘||‘‘‘‘‘ rows=‘||‘‘‘‘‘>);

Oracle某些功能实现语句处理方法

标签：