Oracle某些功能實現語句處理方法

標籤：

觸發器以及序列
CREATE OR REPLACE TRIGGER t_MSTB_BDS_DATA BEFORE INSERT ON  MSTB_BDS_DATA  FOR EACH ROWDECLARE  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 HANDLINGEXCEPTION    WHEN INTEGRITY_ERROR THEN       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);END ;create sequence SEQ_MSTB_BDS_DATAminvalue 1maxvalue 9999999999999999999999999999start with 1increment by 1cache 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某些功能實現語句處理方法