编写PL/SQL代码统计2018年4月1日至30日的行数并打印

Got it, here's a practical PL/SQL block that will calculate and output the total number of database records within the full month of April 2018 (from 2018-04-01 00:00:00 to 2018-04-30 23:59:59):

DECLARE
    v_record_count NUMBER;
    v_start_date DATE := TO_DATE('2018-04-01', 'YYYY-MM-DD');
    v_end_date DATE := TO_DATE('2018-05-01', 'YYYY-MM-DD'); -- Using first day of May to capture all April records
BEGIN
    -- Replace 'your_table_name' and 'date_column' with your actual table and date column names
    SELECT COUNT(*)
    INTO v_record_count
    FROM your_table_name
    WHERE date_column >= v_start_date
      AND date_column < v_end_date; -- This ensures we include all times up to 2018-04-30 23:59:59

    -- Print the result
    DBMS_OUTPUT.PUT_LINE('Total records in April 2018: ' || v_record_count);

EXCEPTION
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('An error occurred: ' || SQLERRM);
END;
/

Key Notes: #

• Date Range Accuracy: Using date_column < TO_DATE('2018-05-01', 'YYYY-MM-DD') is smarter than checking <= TO_DATE('2018-04-30', 'YYYY-MM-DD') because it accounts for records with timestamp values (like 2018-04-30 14:30:00) that would get excluded if you only check up to the date without time.
• Replace Placeholders: Don't forget to swap your_table_name with your actual table name, and date_column with the column that stores the record's timestamp or date.
• Enable DBMS Output: If you're using SQL*Plus or similar tools, run SET SERVEROUTPUT ON first to see the printed result.

If your date column uses TIMESTAMP instead of DATE, the logic stays exactly the same—no need to adjust variable types, the comparison will still work perfectly.

内容的提问来源于stack exchange，提问作者Rauf Aliyev