Oracle Database Operation statements

Commonly used Oracle database operation statements, the following is for reference only:

First, query

1. Query the number of all data bars for a database table that is greater than a certain date

Select COUNT (*) from Alarm_log t where t.alarm_start_time> to_date (' 2017-01-10 08:00:00 ', ' yyyy-mm-dd hh24:mi:ss ');

Querying all historical data for a database table that is larger than a certain date

SELECT * from Alarm_log t where t.alarm_start_time> to_date (' 2017-01-10 08:00:00 ', ' yyyy-mm-dd hh24:mi:ss ');

Second, delete

1. Delete all historical data for a database table that is less than a certain date

DELETE from Alarm_log t WHERE t.alarm_start_time< to_date (' 2017-01-01 08:00:00 ', ' yyyy-mm-dd hh24:mi:ss ');

Oracle Database Operation statements