create or replace procedure
Mon_MultiLevel(p_starttime in string,
---第一次错误
create or replace procedure test_sta(s_time in string, e_time in
string) is
begin
execute immediate('
create or replace view v_district_total_actual
as
select t.district, count(*) as t_sum
from t_warning_list t
where t.start_time >= to_date(s_time,''yyyy-mm-dd
hh24:mi:ss'')
and t.start_time <= to_date(e_time,''yyyy-mm-dd
hh24:mi:ss'')
group by t.district');
end test_sta;
执行的时候,提示错误信息为“无效的列名”
---第二次错误
create or replace procedure test_sta(s_time in string, e_time in
string) is
sqlstr char(1000);
v_start date;
v_end date;
begin
v_start := to_date(s_time, 'yyyy-mm-dd hh24:mi:ss');
v_end := to_date(e_time, 'yyyy-mm-dd hh24:mi:ss');
sqlstr := 'create or replace view v_1 as select t.district,
count(*) as t_sum from t_warning_list t ' ||
'where t.start_tim
