CREATE OR REPLACE PROCEDURE create_tab(TABLE_NAME VARCHAR(30))
AS
BEGIN
EXECUTE IMMEDIATE '
CREATE TABLE '||TABLE_NAME||'("ID" INT NOT NULL,
"STATIONCODE" VARCHAR(10) NOT NULL,
"TIMEPOINT" TIMESTAMP(3) NOT NULL,
"POLLUTANTCODE" VARCHAR(5) NOT NULL,
"MONVALUE" DECIMAL(10,3) NOT NULL,
"MARK" VARCHAR(255) NOT NULL,
"DATASTATUS" INT NOT NULL);';
END;
把+号换成||