Inserting Text Decimal to Table Error

[TheLazyPig]

Hi!

I'm going to import a record into the database.

RECORDS

TABLE

After I import I get this instead.

RESULT

The polno should be the same as records. How can I fix the inserted record?


Thank you!

 

[Andrzejek]

How do you 'import a record into the database'? Do you use some build-in functionality, or do you write the code yourself?

And. how come POLNO is declared as VARCHAR2(50) instead of what it is, a NUMBER?

I guess 9.66671821 to the 7th power = 96667182.1

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[carp]

And as a second guess, I'd bet whatever you are displaying your results with is reformatting your number as scientific notation. Excel is notorious for doing this. Reformat the cell and the results will look the way you expect them too. And like Andy, I'm curious why you would cast your number as a varchar2 - especially if you expect a number as a result.

 

[SkipVought]

And like Andy, I'm curious why you would cast your number as a varchar2 - especially if you expect a number as a result."

I would offer a different perspective as a possibility. It depends on what the polno "number" is. Is this "number" an entity on which you will perform mathematical operations or is this "number" an identifier of some sort, like an invoice id or zip code or member id?

Where and what is RECORDS?

Are there other records that you have not displayed? Sometimes data base managers (systems) make decisions that you don't know about based on "guessing" about certain external data.

And also, was this column varchar BEFORE the data was imported?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[carp]

I don't suppose it really matters why it's a varchar2 - it is what it is. But whatever is being used to display the results is interpreting it as a number and displaying it in scientific notation. The data is fine; the display is off. And the OP is not responding.
So it goes.