Re: external table

Morgan,

sorry there was a mistake in my original question. The question
would be

Can we replace null values with banks or spaces in the external table?

my test file is some thing like

1,name,country,,address,,
2,name,country,,address,,

I am able to create external table with 4,6,7 columns as NULL
I want the data in these columns as blank or spaces.

I am using Oracle 9i.

Thanks.

DA Morgan wrote:
KK wrote:
Can we replace null values with banks in the external table instead of
spaces?

'missing field values are null' replaces with nulls.

any ideas?

Thanks.

Please explain.

1. What version of Oracle?
2. By "replace" do you mean edit the text file?
3. By "replace" do you mean update an external table?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)

.

Relevant Pages

  • [HPADM] Summary: kernel parameters in Oracle environment
    ... >clear whether they are valid for this configuration. ... >had to make repeated changes after Oracle issues. ... >kernel parameters to. ... Inspite of lack of detail in my original question, ...
    (HP-UX-Admin)
  • Re: external table
    ... sorry there was a mistake in my original question. ... Can we replace null values with banks or spaces in the external table? ... my test file is some thing like ... Are you expecting there to be a difference between spaces and NULL? ...
    (comp.databases.oracle.misc)
  • Re: Added hashes.
    ... That of course then begs the original question. ... as an oracle), but still have no idea if it's independent of G. ... E.g. F's oracle keeps track of all previous queries, and responds with a fresh random bitstring for novel queries. ... (I guess this isn't a perfect example, since if all collisions in F were also collisions in G, you'd know they were not independent.) ...
    (sci.crypt)
  • Re: Oracle & Solaris : several oracle product installation
    ... This was your original question ... "Is there any mean to specify to the oracle installer to use one ... oraInst.loc file to point to the oracle inventory of the oracle home ...
    (comp.databases.oracle.server)