oracle表如何移动栏位,Oracle 创建表语句及栏位说明 (不积跬步,无以至千里)

创建表语句

DECLARE num NUMBER;

BEGIN

SELECT COUNT(*) INTO num FROM user_tables WHERE table_name=UPPER('EXAMARRANGEEMPLOYEE');

IF num = 0 THEN

EXECUTE IMMEDIATE

'

create table EXAMARRANGEEMPLOYEE

(

ID NVARCHAR2(36) not null,

ARRANGEID NVARCHAR2(36) not null,

PERSONID NVARCHAR2(36) not null

)';

END IF;

END;

/

-- Add comments to the columns

comment on column EXAMARRANGEEMPLOYEE.ID

is '考评安排人员ID';

comment on column EXAMARRANGEEMPLOYEE.ARRANGEID

is '考评安排ID';

comment on column EXAMARRANGEEMPLOYEE.PERSONID

is '人员ID';

执行更新语句时,最后要COMMIT才能生效

delete from exampubliccodeitem where typeid=1;

insert into exampubliccodeitem(typeid,itemid,itemvalue,available,isreserve,indexcode)

values(1,'1_1','单选题',1,1,1);

insert into exampubliccodeitem(typeid,itemid,itemvalue,available,isreserve,indexcode)

values(1,'1_2','多选题',1,1,2);

insert into exampubliccodeitem(typeid,itemid,itemvalue,available,isreserve,indexcode)

values(1,'1_3','判断题',1,1,3);

COMMIT;