Triggers and sequences
CREATE OR REPLACE TRIGGER t_mstb_bds_data before INSERT on mstb_bds_data for each rowdeclare integrity_ ERROR EXCEPTION; ERRNO INTEGER; ErrMsg CHAR (n); 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;
Insert HTML format statement Implementation method A word Gencun data is in the following format: <input type= ' Radio ' name= ' IDs ' value= ' $ '/>insert into Mstb_bds_data (data _id, NAME_TC) VALUES (' + ', ' <input type= ' | | ' Radio ' name= ' | | ' IDs ' value= ' | | ' The '/> ' format for such is implemented as follows: INSERT INTO Mstb_bds_data ( NAME_TC) VALUES (' '); insert into Mstb_bds_data (NAME_TC) VALUES (' <textarea cols= ' | | ' ' rows= ' | | ' >);
Some Oracle features implement statement processing methods