• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

NOT null constraint in SQL loader URGENT

 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi all
I facing an issue in SQL loader i.e
my input data file is
name id age
------------------
P12
P 3
z89
it is a tab delimited file.
my table will be
CREATE TABLE data1(NAME VARCHAR2(10),id VARCHAR2(10),age NUMBER(3))
i want to include a constraint in ctrl file as
if in the input data if NAME is 'P' then we can't insert null value for id field in the table data1
if the input data for NAME is not equal to 'P' then we can insert null value for id field in the table data1
my sample ctrl file is


How can we handle this kind of constraint in SQL loader?

It is urgent.
Kindly help me out.

[ September 13, 2006: Message edited by: jothish chokkalingam ]
[ September 13, 2006: Message edited by: jothish chokkalingam ]
reply
    Bookmark Topic Watch Topic
  • New Topic