Home » RDBMS Server » Server Utilities » conditional loading into nested tables (SQL Loader 9.2.0.8.0)
conditional loading into nested tables [message #361844] Fri, 28 November 2008 04:31
vboppa
Messages: 22
Registered: November 2008
Junior Member
Dear Forum,

I have a flat file which contains two sets of field structure like in the following.

1|2008-07-05|11:21:51.0|2008-07-05|11:22:10.6|1~ABCD~1000.00~0.00~1~+~2~XYZ~100.00~0.00~2~+~3~ABCDEFGH1~100.00~0.00~1~+~5~ASDGF~83.17 ~15.84~1~+~6~GFDG~100.00~0.00~4~+~7~GFJGH~100.00~0.00~3~+~8~JKGHJ~100.00~0.00~4~+~10~HGJHH~100.00~0.00~1~+~|1

I have created an object for the set of data which is seperated by "~" , on that objected created VARRAY. Then i have created a table for whole record structure which includes VARRAY also.

I have success full loaded, but i need to skip the load of data which Zero(0.00) values in the "~" seperate record structure at nested table.

What is the solution to skip the records at the Nested table Level?
Previous Topic: sqlldr
Next Topic: List of tables in export
Goto Forum:
  


Current Time: Tue Dec 24 10:38:59 CST 2024