davidhooey · October 25, 2013 14:42
diff --git a/oracle_byte_to_char_length_semantics.sql b/oracle_byte_to_char_length_semantics.sql
 select 
    'alter table ' || table_name || ' modify ( ' || column_name || ' varchar(' || char_length || ' char) );'
 from 
    user_tab_columns 
 where 
    data_type = 'VARCHAR2'
 and
    char_used = 'B' 
 order by 
    table_name,
    column_name;
	select
	'alter table ' \|\| table_name \|\| ' modify ( ' \|\| column_name \|\| ' varchar(' \|\| char_length \|\| ' char) );'
	from
	user_tab_columns
	where
	data_type = 'VARCHAR2'
	and
	char_used = 'B'
	order by
	table_name,
	column_name;