Can I execute alter inPL/SQL# Database - 数据库
l*r
1 楼
I have this script to modify sequence but failed in the line of "alter". Can I
execute alter in PL/SQL? Thanks!
declare
seq_name varchar(256);
cursor seq_cursor is
select * from dba_sequences
where sequence_owner = 'XXX';
begin
for seq_val in seq_cursor
loop
seq_name := seq_val.sequence_owner || '.' || seq_val.sequence_name;
alter sequence seq_name nocache;
end loop;
end;
Error message like:
alter sequence seq_name nocache;
*
ERROR at line 10:
ORA-06550: line 10, co
execute alter in PL/SQL? Thanks!
declare
seq_name varchar(256);
cursor seq_cursor is
select * from dba_sequences
where sequence_owner = 'XXX';
begin
for seq_val in seq_cursor
loop
seq_name := seq_val.sequence_owner || '.' || seq_val.sequence_name;
alter sequence seq_name nocache;
end loop;
end;
Error message like:
alter sequence seq_name nocache;
*
ERROR at line 10:
ORA-06550: line 10, co