最近经常要在程序中创建不同的表
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成功