Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mpls51

    Oracle PL/SQL

    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...
  2. mpls51

    Oracle PL/SQL

    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...
  3. mpls51

    Oracle PL/SQL

    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.
  4. mpls51

    Oracle PL/SQL

    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)...
  5. mpls51

    Oracle PL/SQL

    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)...
  6. mpls51

    Oracle PL/SQL

    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...

Part and Inventory Search

Back
Top