Re: external table

From: DA Morgan <damorgan@xxxxxxxxx>
Date: Wed, 29 Mar 2006 11:38:22 -0800

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

Follow-Ups:
- Re: external table
  - From: KK

References:
- external table
  - From: KK

Prev by Date: Re: Indexing properties that belong to types
Next by Date: Re: xmltype extract concatenates the results
Previous by thread: external table
Next by thread: Re: external table
Index(es):
- Date
- Thread

Relevant Pages

How to support NULLs in XSD?
... designer. ... The Oracle table allows nulls. ... Is there a way to set these without having to open the .VB file and edit it? ...
(microsoft.public.dotnet.languages.vb)
How to support NULLS in XSD
... designer. ... The Oracle table allows nulls. ... Is there a way to set these without having to open the .VB file and edit it? ...
(microsoft.public.data.ado)
Re: Indexes and -Null- values
... > I've encountered this problem running Oracle 9i. ... > same issues with nulls exist outside of the Oracle product... ... > Database Designers tend to try to minimize the use of NULLABLE columns ...
(comp.databases)
Re: Indexes and -Null- values
... > I've encountered this problem running Oracle 9i. ... > same issues with nulls exist outside of the Oracle product... ... > Database Designers tend to try to minimize the use of NULLABLE columns ...
(comp.databases)
Re: query enhancement
... key constraint. ... Frank van Bortel ... Since you are going to update all NULLs to non-NULLs anyway, ... Oracle will full scan the ...
(comp.databases.oracle.server)