create or replace procedure modifychartovarchar is --
cursor c1 is
select t.TABLE_NAME, t.COLUMN_NAME, t.DATA_LENGTH
from all_tab_columns t
where t.OWNER = 'LANDUSER' and t.DATA_TYPE = 'CHAR'
create or replace procedure modifychartovarchar is --
cursor c1 is
select t.TABLE_NAME, t.COLUMN_NAME, t.DATA_LENGTH
from all_tab_columns t
where t.OWNER = 'LANDUSER' and t.DATA_TYPE = 'CHAR'