Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I ensure order of rows loaded by SQL Loader?
puneet.bansal_at_wipro.com (Puneet) wrote in message news:<4c276d80.0311130404.3bcd0581_at_posting.google.com>...
> Thanks Jim for your response.
> The correct order is the order specified in the CSV file. The first
> record is the name of a person with a tag attached to it 'Contact'.
> The next 4 records are just names without the keyword 'Contact' in
> them, so I know that these 4 people are associated with the first
> 'Contact'. The next record is again a 'Contact', so I know that this
> is a new contact and then again there are people associated with this
> contact. So if I traverse by order I know which people to associate
> with what contact. So that's why the order bocomes important. You are
> right that I can define a column having sequence numbers but the
> problem is I am loading the data using sql loader. How do I insert
> sequence numbers while loading the data from sql loader? Is there any
> way a sequence number is auto inserted in a column?
You might consider reading up on "normalization" "entities" and "attributes" so you don't unintentionally wind up with a denormalized table in a relational database.
jg
-- @home.com is bogus. http://www.datamodel.org/NormalizationRules.htmlReceived on Fri Nov 14 2003 - 16:53:31 CST