Re: PL/SQL general question

<mustang4u_at_home.com> wrote in message news:3bb51397.462719185_at_news...
> I am new to programming and have been asked to write a program to
> produce keywords from several description fields in a database. The
> main requirement is speed! My question is weather PL/SQL is an
> appropriate language to do this type of manipulation. Or if it is
> better left to a higher language like Pro c. From what I have read
> this is not impossible to do in SP/SQL but my impression so far is the
> language was meant to handle more database report type programs.
>
> The program would have to :
> Read strings from a table
> Tokenize them
> Remove any duplicates
> Strip special characters
> Write them to a table with a unique identifier
>
> Any opinions would be great
>
> Thanks Kevin
>

If you do it properly in pl/sql, writing a procedure or a package, the main advantage is you don't have to fetch the data to a client. Pro*C is going to fetch them always to a client.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Sep 29 2001 - 05:58:59 CEST