Home » RDBMS Server » Server Utilities » Can I replace 0 instread "N/A" HELP!!
Can I replace 0 instread "N/A" HELP!! [message #70308] Thu, 23 May 2002 02:57 Go to next message
kullawat
Messages: 3
Registered: April 2002
Junior Member
if my data have "N/A"
Can I replace 0 instread "N/A" in control file

How can i create control file. Help pls

if my data
----------------------------
usr data1 data2
8 20 1.5
9 1.26 N/A
10 N/A 9

Report message to a moderator

Re: Can I replace 0 instread "N/A" HELP!! [message #70375 is a reply to message #70308] Tue, 04 June 2002 12:53 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
try
"replace(:data-x, 'N/A', '0')"

Report message to a moderator

Previous Topic: concatenate parts of a row in sql loader
Next Topic: Export Error EXP-00008
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 25 04:17:12 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.