{ TABLE "infwork".dm_sex row size = 19 number of columns = 3 index size = 0 }
create table "infwork".dm_sex
(
e_expr char(1),
c_expr char(14),
c_brif char(4)
);
revoke all on "infwork".dm_sex from "public";create unique index "infwork".ix150_1 on "infwork".dm_lry (code_people)
using btree ;如何写成ORACLE 脚本
create table "infwork".dm_sex
(
e_expr char(1),
c_expr char(14),
c_brif char(4)
);
revoke all on "infwork".dm_sex from "public";create unique index "infwork".ix150_1 on "infwork".dm_lry (code_people)
using btree ;如何写成ORACLE 脚本
是用来执行的sql脚本呢?还是需要写出shell脚本呢?
(e_expr char(1),
c_expr varchar2(14),
c_brif varchar2(4)
);--收回dm_sex表对public的所有权限
revoke all on dm_sex from public;--为dm_lry表创建一个唯一索引
create unique index ix150_1 on dm_lry(code_people);