Hello All,
In order to learn my column data type and length I run the following query. However, when I confirm it with desc table_name command, I see that data lengths are not match. Do you have any idea?
>>select column_name||' '||data_type||'('||data_length||')' col_info from all_tab_columns where table_name = 'CUSTTABLE' and column_name = 'ACCOUNTNUM';
>>ACCOUNTNUM NVARCHAR2(24)
>>desc CUSTTABLE;
>>ACCOUNTNUM 1 N NVARCHAR2 (12)
Regards
Charlie