Re: Another interview question

Just my $0.02, but couldn't you just create a view based on this table and add an integer column? Later the changeover can be transparent to the users. This is a real interview question? from where?

• Dread

Michael Serbanescu <mserban_at_postoffice.worldnet.att.net> wrote:

: "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