Get Maximum Column Length
397699Jul 9 2003 — edited Jul 9 2003Hi all,
Is there any way that we can check the max length available for a number column?
for example, there's a table called TEMP_TABLE, with 2 columns, col1 of type NUMBER(3) and col2 of type VARCHAR(10)
let say, as a programmer, I need to fill in col1 as a running number (1,2,..,999), and before inserting, i need to check whether I have reached the max number or not (otherwise, no more insertion will be allowed)
is there any special table that I can use to check on this information (which is, finding out that col1 in TEMP_TABLE is 3 digit max), like in data dictionary maybe?
(i know that the best way is to use sequence, and let say that using sequence is not allowed)