Does this query show your column name?
Do you have any miscellaneous characters around the new column name?
Post the results of this query.
Code:SELECT table_name, '|' || column_name || '|', data_type FROM all_tab_columns WHERE owner = 'SCHEMAOWNER' AND table_name = 'YOURTABLE_NAME' ORDER BY column_id;




Reply With Quote