Oracle简单删除语法
1. 按删除时间段内所有数据
delete from 表 where
to_char(时间列,'yyyy-mm-dd')>='2020-01-01'
and to_char( 时间列,'yyyy-mm-dd')<='2020-01-30';
2. 删除列
alter table employee_info drop column introduce;
3. 清除表中所有数据
truncate table employee_info; (DELETE FROM table_name或DELETE * FROM table_name)
4. 删除表
drop table employee_info;
5. 删除存储过程
DROP PROCEDURE 存储过程名字