oracle两条语句同时,C# Oracle同时执行多条sql语句

最近经常要在程序中创建不同的表

create table TableName

(

Id NUMBER not null,

Age NUMBER not null,

Name NVARCHAR2(50)

);

comment on column TableName.Id is

'comment';

comment on column TableName.Name is

'comment';

comment on column TableName.Age is

'comment';

执行时会报错 ORA-00911: 无效字符 加上BEGIN END 也还是报错

BEGIN

EXECUTE IMMEDIATE

'create table TableName

(

Id NUMBER not null,

Age NUMBER not null,

Name NVARCHAR2(50)

)';

EXECUTE IMMEDIATE

'comment on column TableName.Id is

''comment''';

EXECUTE IMMEDIATE

'comment on column TableName.Name is

''comment''';

EXECUTE IMMEDIATE

'comment on column TableName.Age is

''comment''';

END;

cmd.ExecuteNonQuery成功