PL_SQL生成时间维度表

--DROP TABLE dim_time;

CREATE TABLE dim_time (
  time_key char(8) PRIMARY KEY,
  time_value char(10) UNIQUE,
  hours24 number(3) NOT NULL,
  hours12 number(3) DEFAULT NULL,
  minutes number(3) DEFAULT NULL,
  seconds number(3) DEFAULT NULL,
  am_pm char(4) DEFAULT NULL
) ;




CREATE OR REPLACE PROCEDURE SP_GENERATE_TIME_DIMENSION is

  /*生成时间维度数据*/

  dDate date;

  v_time_key char(8);
  v_time_value char(10);
  v_hours24 number(3);
  v_hours12 number(3);
  v_minutes number(3);
  v_seconds number(3);
  v_am_pm char(4);