SQL & PL/SQL

Hi,
I have a table called "TEST" with columns "column1" and "column2". when I am trying to insert '0' value into column2. It is displaying as NULL.

Here the example

Create table TEST (column1 varchar2(20), column2 number(10,2));

insert into TEST values ('AAAA','6.0');
insert into TEST values ('BBBB','0');
insert into TEST values ('CCCC','8.0');
insert into TEST values (DDDD','0');

select * from TEST;

RESULTS:

column1 column2
AAAA 6
BBBB
CCCC 8
DDDD


expected result:

column1 column2
AAAA 6.0
BBBB 0
CCCC 8.0
DDDD 0

Edited by: user11872870 on Sep 23, 2010 1:51 PM