Search results for query: *

Sorry about the syntax errors. I'm a novice when it comes to PL/SQL but I'll try to take a crack at writing the algorithm but could you provide some resources on how to remove punctuation and separating out/parsing all words. As far as "Golbet" I unintentionally misspelled it should be...

Here is the sql statements smc_book table: create table smc_book (smc_id number(5), smc_title varchar2(80), smc_publisher varchar2(80), smc_release_date date); insert into smc_book values (1234, 'Beautiful Wonder', 'Wrox Books', 'Jan-01-1999'); insert into smc_book values (2356, 'Master...

Thanks for your help. Now I just need to match up "Beautiful Wonder" in the smc_book file with "Wonder, Beautiful" in the arc_book table even though the title and publisher data is not exact.

Thanks for the informative reply. I think i'll go with external tables. After reading the link you provided and cutting and pasting heres what I came up with. CREATE TABLE EXT_SMC_BOOK ( smc_id number(5), smc_title varchar2(80), smc_publisher varchar2(80)...

Thanks for the informative reply. I think i'll go with external tables. After reading the link you provided and cutting and pasting heres what I came up with. CREATE TABLE EXT_SMC_BOOK ( arc_id number(5), arc_title varchar2(80), arc_publisher varchar2(80)...

I have the following table in oracle 9i: arc_book ---------------------------------------------------------------------------------------------- arc_id, arc_title, arc_publisher, arc_release_date And a tab delimited file called smc_book. Here is how the smc_book tab delimited file looks like...