Empty records

[ferreiran]

I am experiencing a problem with Oracle 10g express edition. For some reason records are created with a timestamp but the fields in the colums (of type NUMBER) are recorded as '-'
Here is the script for creating the table:
CREATE TABLE "UNSIGNED"
( "FCHMITIMESTAMP" TIMESTAMP (6),
"NUMERICVAL_1" NUMBER,
"NUMERICVAL_2" NUMBER,
"NUMERICVAL_3" NUMBER,
"NUMERICVAL_4" NUMBER,
"NUMERICVAL_5" NUMBER,
"NUMERICVAL_6" NUMBER,
"NUMERICVAL_7" NUMBER
)
Any inputs?

Thanks

 

[Dagon]

How are you populating the table? What are you populating it with? What are you using to view the data?

For Oracle-related work, contact me through Linked-In.