Help - Search - Members - Calendar
Full Version: Unable to extract NULLS
Oracle DBA Forums > Oracle > Oracle Forum
ulab
Hi All,

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.??

Many thanks
burleson

>> but, NULLs in oracle tables are getting converted into space

NULL IS lirerallly NOTHING!

CODE
spool flatfile,txt

select col1, nvl(col2,' '), col3

spool off;

!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=scholart

A NULL <> Zero <> space
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.