為了增強健壯性,可以先判斷是否存在該oldName:
create or replace RenameTable(oldName string,newName string)
as
sql string(1000);
v_i integer;
begin
select count(*) into v_i from tab where table_name=''||oldName||'';
if v_i>0 then
sql='alter table '||oldName||' to '||newName||;
execute imediate sql;
end if;
end RenameTable;
/
create or replace RenameTable(oldName string,newName string)
as
sql string(1000);
begin
sql='alter table '||oldName||' to '||newName||;
execute imediate sql;
end RenameTable;
/
procedure ModifyFieldName
(
in_NewName in varchar2,
out_result out varchar2
)
is
begin
alter tablename
modify fieldname in_NewName
out_result := 0;
exception
when others then
out_result := 1;
end;