Oracle import pipe delimited file

SetName : Name of the reference data set. Here's a sample file that contains the header values at the beginning and lists four set enabled lookup codes to be imported. For importing several lookup codes, add more entries in the same format. Previous Next JavaScript must be enabled to correctly display this content.

While creating the file, adhere to the following guidelines: Use a vertical bar or pipe as a delimiter between fields for both header and value rows. The following sections contain details about the specific lookup types and codes. Prerequisite You must have worked with lookups in Oracle Cloud applications. Standard and Common Lookups The lookup types and codes are similar for standard and common lookups. To create a file containing the lookup types, include the following headers: LookupType : The lookup type.

ModuleKey : The module code. Required headers: LookupType : The lookup type. Optional headers: StartDateActive : Beginning of the date range during which the lookup code is active and visible on the page. Now I create a third table which has columns from table1 and few columns from table2.

I get the data from table1 and table2 in 2 separate text files. I have to use sql loader to select the data from both the files and insert into single row of table3. Is this possible using sql loader? Or do I have to load both the files into 2 separate tables and then run a query to insert into table3? Please explain. Let me know if there are better options to achieve this. This will be used in our datawarehouse loading process. Thanks in advance. July 29, - am UTC.

I forgot to mention that it is oracle 8. What is the other option? July 30, - am UTC. A reader, November 07, - am UTC. November 07, - pm UTC. Mohit, October 22, - pm UTC. Name required. FitWell Physiotherapy Clinic. Follow Following. Know-Oracle Join other followers. Sign me up. Already have a WordPress. Log in now. Post was not sent - check your email addresses! Sorry, your blog cannot share posts by email.