oracle

1 修改已有表中某个字段的长度
alter table noticeinfo
MODIFY province varchar(4000);

COMMIT;

2 选择时限制不为空
"select distinct dzh,gslb from qhgsfuturetype where dzh is not null and gslb is not null";