SQL*LDR, DIirect Path load and NOT NULL with default

Author: asktom.oracle.com | Published: 5th Jan 2008 | Visited: 46 times | Add Comment
Filed in: Oracle FAQ

If I have a table, eg: create table chris (col1 varchar2(3) default 'xyz' not null); I want to load it with SQL*Loader. If some of the rows have an empty string, the column will be populated with 'xyz' provided I use the conventional path. Is...

Read Article

Sponsored Links

• Speeding Up Post Load Script Post-load script maybe one of the most challenging tasks for developers especially those that use a framework for building an Ajax application. In a framework setting, developers will always work in a setting wherein JavaScript is involved. When post load happens, developers will be limited in thei ...

• Querying SQLServer tables from within an Oracle session Dear Tom; I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like: <CODE> select * from t@sql_server_link </CODE> May you redirect me to the appropriate documentati ...

• Setting Default Values on Automatic Properties An article on implementing default values on Automatic Proper ...

• Dynamically generating thumbnail images in ASP.NET with C# without affecting initial page load time Generate thumbnail on the fly without affecting page load ...

• How to Disable TEdit's Default PopUp (Context) Menu in Using VCL :: When a user right-clicks on an Edit component at run time (or any other component that allows editing such as MaskEdit, Memo, DbEdit, etc.), by defaul ...

• Can we change default TIMESTAMP (6) precision per session or database? While trawling David Aldridge's site http://oraclesponge.wordpress.com/2008/03/07/timestamps-old-fogeys-and-data-warehouses/ I wondered, but could not find in the documentation: Is there any way of changing the default precision of 6 for TIMESTAM ...

• How to load entire database into memory Hi Tom, I have an Oracle Database 8.1.7.4 Standard Edition installed on a Windows 2000 Server. My question is for curiosity more than need. Let's assume that we have enough physical memory and that we can guarantee that the server will neve ...

• A class to load and use file associated icons An article about using SHGetFileInfo in C# (simple class and demo are inclu ...

• Fast Priority Queue Implementation of Dijkstra Shortest Path Algorithm Need a fast, efficient algorithm to compute the shortest path in C ...

• Message box with any number of buttons and ?apply-my-answer-by-default? checkbox. Message box with any number of buttons and ?apply-my-answer-by-default? check ...

Next: I want know how to prevent select for update from users without update grant.