[locky_sql_ru]

у меня number расходится например в 'LEDGERBALANCES','ADDRESS'
В 'ADDRESS' - number(32,16), в 'LEDGERBALANCES' - просто number

 
select so.name,sd.name,sd.fieldtype,tc.DATA_TYPE,tc.DATA_PRECISION,tc.DATA_SCALE
,sd.* 
from administrator.sqldictionary sd join administrator.sqldictionary so on sd.tableid=so.tableid and sd.fieldid <> 0 and so.fieldid = 0
join sys.all_tab_columns tc on sd.name=tc.COLUMN_NAME and tc.TABLE_NAME = so.name
where tc.DATA_TYPE = 'NUMBER'
and sd.fieldtype = 2 
and sd.name in ('CREDITMST','LINENUM')
and so.name in ('LEDGERBALANCES','ADDRESS')

получил

 
NAME NAME FIELDTYPE DATA_TYPE DATA_PRECISION DATA_SCALE TABLEID FIELDID ARRAY NAME SQLNAME FIELDTYPE STRSIZE SHADOW RIGHTJUSTIFY NULLABLE FLAGS RECVERSION RECID
ADDRESS LINENUM 2 NUMBER 32 16 1 3 1 LINENUM LINENUM 2 0 0 0 0 0 1 5637145421
LEDGERBALANCES CREDITMST 2 NUMBER   1356 9 1 CREDITMST CREDITMST 2 0 0 0 0 0 1 5637173370