Dec 20 2011, 02:15 AM
Am trying to extract data from oracle onto flatfile(.txt), am using UTL_FILE but, NULLs in oracle tables are getting converted into space and if i try loading into table it is getting loaded as space, any solution for this.??
Dec 20 2011, 07:35 AM
>> but, NULLs in oracle tables are getting converted into space
NULL IS lirerallly NOTHING!
select col1, nvl(col2,' '), col3
!cat flatfile.txt abc def
Use NVL and make the NULL whataver character you want!
READ HERE: http://scholar.google.com/scholar?q=relati...amp;oi=scholartA NULL <> Zero <> space