<div>
This was made for SQL Loader. &nbsp;You can use it to load into multiple tables. 
 
There are examples out there: 
<a href="http://www.dba-oracle.com/t_sql_loader_multiple_tables_sqlldr.htm" rel="ugc">http://www.dba-oracle.com/t_sql_loader_multiple_tables_sqlldr.htm</a>
</div>

<div>
<div class="content wysiwyg-content">
How can i do below have a flat file like below: 
 
&nbsp; 
 
T|B|P04|WN4|0018025196|2014-04-14T13:01:17Z|ET3|USD|2.00|4/4/5/7|2.00| 
 
T|B|P04|WN4|0018025314|2014-04-14T13:01:17Z|ET3|USD|2.00|4/6/2/7|2.00| 
 
T|B|P04|WN4|0018025472|2014-04-14T13:01:17Z|ET3|USD|2.00|4/6/8/7|2.00| 
 
T|B|P04|WN4|0018025590|2014-04-14T13:01:17Z|ET3|USD|2.00|4/7/3/7|2.00| 
 
$|N| 
 
S|N| 
 
P|WIN|2014-04-14T21:01:17Z| 
 
P|PLC|2014-04-14T21:01:17Z| 
 
P|SHW|2014-04-14T21:01:17Z| 
 
P|EX |2014-04-14T21:01:17Z 
 
&nbsp; 
 
Want to handle a file where each row can be a different record format, 
 
which is determined by the first Character in the row. 
 
Then each row processed into 1 of 7 separate tables? 
 
&nbsp; 
 
Example: 
 
&nbsp; 
 
T row will go table A 
 
$ row will go table B 
 
P row go in table C and so on.
</div>
</div>

How can i do below have a flat file like below:

 

T|B|P04|WN4|0018025196|2014-04-14T13:01:17Z|ET3|USD|2.00|4/4/5/7|2.00| 

T|B|P04|WN4|0018025314|2014-04-14T13:01:17Z|ET3|USD|2.00|4/6/2/7|2.00| 

T|B|P04|WN4|0018025472|2014-04-14T13:01:17Z|ET3|USD|2.00|4/6/8/7|2.00| 

T|B|P04|WN4|0018025590|2014-04-14T13:01:17Z|ET3|USD|2.00|4/7/3/7|2.00| 

$|N| 

S|N| 

P|WIN|2014-04-14T21:01:17Z| 

P|PLC|2014-04-14T21:01:17Z| 

P|SHW|2014-04-14T21:01:17Z| 

P|EX |2014-04-14T21:01:17Z

 

Want to handle a file where each row can be a different record format,

which is determined by the first Character in the row.

Then each row processed into 1 of 7 separate tables?

 

Example:

 

T row will go table A

$ row will go table B

P row go in table C and so on.

This was made for SQL Loader.  You can use it to load into multiple tables.

There are examples out there:
http://www.dba-oracle.com/t_sql_loader_multiple_tables_sqlldr.htm

Loading flat file data in tables

C is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations. By design, C provides constructs that map efficiently to typical machine instructions, so it has found lasting use in applications that had formerly been coded in assembly language, including operating systems as well as various application software for computers ranging from supercomputers to embedded systems. It is distinct from C++ (which has its roots in C) and C#, and many later languages have borrowed directly or indirectly from C.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.