-
HI,
I ve written a procedure which reads data from data file and inserts it in to a table in the d/b
Now ive given all the cols in my tables as not null(company rule)..lol
Now the data file contains null data at some places...
Now Ive made it clear in the proc that if i find a null data ,replace it with ' '.
But still it doesn't :(
I even tried giving the default value for each col as ' '.
Even that doesn't work
pls help
Any kinda suggestion is invited.
thanx a lottttttttt
-
pls show your table and proc, it will be easier to find why it doesn't work )
-
Try using a string like 'NULL' or 'EMPTY'. It is an ugly fix, but this is not really a technical issue.
Why are all columns NOT NULL when it does not reflect the state of the business?
Good luck.
David Knight
OCP DBA 8i, 9i, 10g
-
I still cannot get throgh with this...
value:=LTRIM(RTRIM(value,' '),' ');
if value=null then
value:=' ';
end if;
I ve given this to replace null with empty strings
thanx
-
test using :
value := nvl(value,' ')
BTW : testing nullity using '= null' is not recommended, you should use 'is null'
-
THANXXXXXXXXA LOTT GUYSSS
I dunno how to thank u guys...
thanx again
-
U can use NVL(abc,' ') or give default values to the columns
There Nothing You cannot Do, The problem is HOW.
-
U can use NVL(abc,' ') or give default values to the columns
There Nothing You cannot Do, The problem is HOW.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|