Another interview question

[Quoted] [Quoted] "A production database table contains a column defined as NUMBER(6,2). [Quoted] However, at this point in the life of the application using the table, [Quoted] *only integer numbers* can be used (although this may change in the [Quoted] [Quoted] future, hence the column format). All the values currently contained in [Quoted] the column are integers. Can you, the ORACLE DBA, provide as soon as [Quoted] possible, a solution to this problem, i.e. allow only integers in that [Quoted] column ? Your solution must have minimal or no impact on the [Quoted] application, be easy to implement, flexible and generic."

Michael Serbanescu Received on Wed Jul 09 1997 - 00:00:00 CEST