Re: Direct Path APIs & sequences
Date: 22 Apr 2003 00:43:47 -0700
Message-ID: <a20d28ee.0304212343.32027ec1_at_posting.google.com>
momossa_at_yahoo.com (Mohamed) wrote in message news:<20a5af10.0304202341.7f928e71_at_posting.google.com>...
> Hi guys,
> I'm using Oracle Direct Path APis to load data from huge files into DB
> table. I need to use some feature that are provided in SQL Loader
> like:
> generating sequence for DB column for each inserted record. How can I
> acheive that using DP?
>
> Also I want to split some fileds from the file into multiple columns
> depending on some criteria, ex. File (Name) --> (DB) [First Name] &
> [Last Name]
>
> Thanx in advance
1 You can't. Triggers don't fire
2 just use an appropiate function definition as outlined in the documentation
column ":<function call>"
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Tue Apr 22 2003 - 09:43:47 CEST