Oracle 的检测表栏位存在,再新增表栏位 (不积跬步,无以至千里)

-Add P5回复字段 到 Carrform1 表內
IF COL_LENGTH('FORM1','P5_Reply') IS NULL
BEGIN
  ALTER TABLE FORM1 ADD P5_Reply NTEXT
  PRINT 'Succedded to Add Column ReFillTxt to FORM1!'
END
ELSE
BEGIN
  PRINT 'There Exists the Column ReFillTxt of FORM1!'
END