| sqlldr WHEN clause [message #59361] |
Thu, 13 November 2003 08:40  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
|
can i use "WHEN" clause in SQL Loader control file scripts. when my data is |(pipe) delimited. please urgent..
|
|
|
|
| Re: sqlldr WHEN clause [message #59385 is a reply to message #59361] |
Fri, 14 November 2003 13:22  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
Yes, you can use a "WHEN" clause to load delimited data
based on a condition. Example:
...
WHEN (deptno = '10') AND (job = 'SALES') .
...
See chapter 5 of the "Oracle9i Database Utilities" guide for
more details.
Best regards.
Frank Naude
|
|
|
|
|
|
|
|
| Re: sqlldr WHEN clause [message #61209 is a reply to message #59361] |
Mon, 05 April 2004 13:06 |
Milind
Messages: 8
Registered: February 2002
|
Junior Member |
|
|
Is it possible to use line numbers in when clause. I need to load the header lines into a separate tables.
for example
into table A
when line_number = 1
..
..
into table B
... -- load rest of the data
is this possible ? if so what is the syntax for doing so
thanks
|
|
|
|
| Re: sqlldr WHEN clause [message #61449 is a reply to message #59386] |
Sat, 24 April 2004 09:37 |
akif
Messages: 4
Registered: November 2002
|
Junior Member |
|
|
i want to use 'OR'. how can i do.
field1 field2 field3
5263265 0254653262 20011123
5634654 0253154623 20011026
8564685 2563658 20010923
6548525 4856852 20010502
4652332 523 20010801
8659565 as 452326 20010308
8976546 eedv456824656 20010405
i want to
if field2 starts with '0', first charachter don't write
if field2 of lenght is 7, i want to insert to field2 of head '366'
else i want to take default
i mean
field1 field2 field3
5263265 254653262 20011123
5634654 253154623 20011026
8564685 3662563658 20010923
6548525 3664856852 20010502
4652332 523 20010801
8659565 as 452326 20010308
8976546 eedv456824656 20010405
how can i do
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
