| want to modify multiple empty tables [message #90471] |
Wed, 05 November 2003 06:27  |
Emma
Messages: 12
Registered: November 2001
|
Junior Member |
|
|
Hi,
I have 45 tables that contain a field called 'CODE' which has a datatype of VARCHAR2 and data length of 5.I
want to modify all these tables so that the CODE field will have a data length of 6.
I have tried running the following .sql but i am getting the below errors.
begin
for v in (select * from dba_Tab_columns where owner = 'USER' and column_name = 'CODE'
and data_type = 'VARCHAR2' and data_length = 5)
loop
execute immediate 'alter table USER.'||v.table_name||' modify '||v.column_name||'
varchar2(6)';
end loop;
end;
|
|
|
|
| Re: want to modify multiple empty tables [message #90474 is a reply to message #90471] |
Fri, 07 November 2003 14:20  |
inna
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
you forgot to include parenteces, and you need empty space between column name and datatype
like this:
execute immediate 'alter table USER.'||v.table_name||' modify ('||v.column_name||' varchar2(6))'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
