更改某一个字段alter table tb_test modify permile number(5,2);
搜索特定index的数据 例子(20到29)
SELECT * FROM (SELECT * FROM gj_npd_mstr t ORDER BY processid ) WHERE ROWNUM<30
MINUS
SELECT * FROM (SELECT * FROM gj_npd_mstr t ORDER BY processid ) WHERE ROWNUM<20
添加删除字段
1、添加字段
alter table table_name add column1 type add column2 type add column3 type ... ;
2、删除字段
alter table table_name drop column column_name
搜索特定index的数据 例子(20到29)
SELECT * FROM (SELECT * FROM gj_npd_mstr t ORDER BY processid ) WHERE ROWNUM<30
MINUS
SELECT * FROM (SELECT * FROM gj_npd_mstr t ORDER BY processid ) WHERE ROWNUM<20
添加删除字段
1、添加字段
alter table table_name add column1 type add column2 type add column3 type ... ;
2、删除字段
alter table table_name drop column column_name