how to insert space inside a column
534426Oct 8 2006 — edited Oct 10 2006I have a column declared not null which I am trying to insert. I get data from other column with is varchar2(200) , I substr(case,4,2) and try to insert and its giving error that some value in not null column. I think my substring is not bringing any value. So if its doesnt bring any value , i need to substitue and insert space into columns, how to do it , i am newbie
Also in oracle , if we dont insert any value in a Date defined column what will be value in table. Will it be null or space.
Thanks