|Parsing and searching for each row [message #338900]
||Wed, 06 August 2008 04:07
Registered: March 2008
I have two set of txt files.|
1) Links - 1 million records
2) Projects - 500 records
I need to know how to search in the link if a project is present in that link and map it back to the projects.
11X3 O2W HUA00 ETH-1.5M001
11X8 O2U D1000 MUL0001
11X8 O2U D1000 MUL0002
So as you can Link1 has two sites which is divided into two columns SiteA =11X3 SiteB =02W
And goes on....
There are some rubbish data which is no way there is any site in this
which can be ignored.
Is there a parsing mechanism to go through row by row in oracle.How to start on this?
LINKCODE VARCHAR2(50 BYTE)
--1 million records
In every record/row in table_link will be associated with a site_code in table_projects.
I need to create 2 columns in TABLE_LINKs as SiteA,SiteB.(e.g 11X3 ,O2W )
as the nature of data has two site code or maybe one.
Some are rubbish links which cannot track down the site_code.
Teh position of teh siteA,SiteB in the table_link can be anywhere.
How do we do a search in the 1 million records whether each row contains any of teh 500 records in Table_projects.
[Updated on: Wed, 06 August 2008 04:11]
Report message to a moderator