oracle query for column size
select char_length from all_tab_columns where table_name = 'YOUR_TABLE_NAME and column_name ='YOUR_COLUMN_NAME'
you can use it if you want to do validations on fields before you enter the value to database why repeat code? simply get dynamically to a static variable the column size.
DRY - Don't Repeat Yourself.
select char_length from all_tab_columns where table_name = 'YOUR_TABLE_NAME and column_name ='YOUR_COLUMN_NAME'
you can use it if you want to do validations on fields before you enter the value to database why repeat code? simply get dynamically to a static variable the column size.
DRY - Don't Repeat Yourself.
Comments