create
procedure
referesh_zhaogw(
in
odd_table_name
varchar
(
100
),
in
ods_table_name
varchar
(
100
))
language sql
begin
declare sSql varchar ( 1000 ) ;
set sSql = ' create table ' || ods_table_name ||
' as select * from ' || odd_table_name ;
prepare s1 from sSql;
execute s1;
end ;
language sql
begin
declare sSql varchar ( 1000 ) ;
set sSql = ' create table ' || ods_table_name ||
' as select * from ' || odd_table_name ;
prepare s1 from sSql;
execute s1;
end ;