Issue
If it is a string column, I can insert null or empty value with ''
, but what about the decimal column, Null
or -99999
? Thanks so much for any advice.
Solution
You can insert null values into the table with a column type integer. Empty_string and null is the same in oracle.
Eg:
create table t(x int)
insert into t values('')
insert into t values(null)
select count(*),count(x)
from t
https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=e7653cf554a9e19a8ae47f1c101218ff
Answered By - George Joseph Answer Checked By - Dawn Plyler (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.