这个触发器要怎么写呀!!(sqlserver->oracle)在线等!!!
我原来在sqlserver上做开发,现在要把系统移植到 oracle上,请问大家这个触发器怎么写呀?
代码如下:
CREATE Trigger OnInsertBbname
on dbo.bbname
for insert
as
declare @bbname varchar(20)
declare @Sql varchar(1000)
select @bbname = bbname from inserted
--创建新表
if Not Exists( select * from Sysobjects where id = object_id(N'[dbo].['+@bbname+']') and objectproperty(id,'IsUserTable')=1 )
begin
set @Sql =
'Create Table temptable'+
'(
temp varchar(10)
)'
exec(@Sql)
end