Another interview question

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/07/09
Message-ID: <33C33B86.5131@postoffice.worldnet.att.net>#1/1

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

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