),age )) create or replace trigger gger_tt before insert on ttt for each row when (new.id is null) begin select ttt_sequence.nextval into :new.id from dual; end;
语法: select x into new_tableName from ori_tableName 例如: SELECT [site] ,[day] ,[val]/31.4 [val] into t_init FROM [RainFactor].[dbo].[t_factor] order by [site],[day]