loading sequential file to Oracle CLOB
Posted: Wed Sep 22, 2010 3:50 pm
I am given a requirement to load a sequential file to oracle table.
The sequential file has 133 rows, each row has a final delimiter end.
In the Oracle table, there are two coulmns
1.Clob column
2.filename column.
In the clob column , I need to load load the entire 133 rows as a single row..
When I loaded the data, it is loaded as 133 rows in clob.
Is the requirement a valid one? Can we really achieve this requirement (loading 133 rows delimited by end character into oracle clob as a single row)?
The sequential file has 133 rows, each row has a final delimiter end.
In the Oracle table, there are two coulmns
1.Clob column
2.filename column.
In the clob column , I need to load load the entire 133 rows as a single row..
When I loaded the data, it is loaded as 133 rows in clob.
Is the requirement a valid one? Can we really achieve this requirement (loading 133 rows delimited by end character into oracle clob as a single row)?