On a logical level perhaps.
Try coding it. It will also be slow.
Perl is *much* faster for something like this.
Jared
On Tuesday 02 October 2001 06:00, Nicoll, Iain (Calanais) wrote:
> I'm sure Perl would be more efficient especially as you don't have to name
> the columns, but if you don't have to worry about the combined columns
> being too large isn't it equivalent to
>
> select col1||'|'||col2 etc
> from table
> having col1||'|'||col2 etc like '%value%'
>
> Iain Nicoll
>
> -----Original Message-----
> Sent: 02 October 2001 13:00
> To: Multiple recipients of list ORACLE-L
>
>
> HELL of a reason to learn Perl!
>
> Nice..
>
> Mark
>
> -----Original Message-----
> [EMAIL PROTECTED]
> Sent: Monday, October 01, 2001 20:51
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> <PerlEvangelism>
>
> my $dbh = DBI->connect(
> 'dbi:Oracle:' . $db,
> $username, $password,
> { RaiseError => 1, AutoCommit => 0 }
> );
>
> die "connect failed\n" unless $dbh;
>
> my $sql='select * from persons;'
> my $sth = dbh->prepare($sql) || die
> my $rv = $sth->execute || die "error in execution\n";
>
> while ( my $arrarRef = sth->fetchrow_arrayref ) {
> my @array = @{$arrayRef};
> if ( grep(/\s+hoser\s+/gi, @array ) ) {
> print "Hey! I found a hoser!\n";
> }
> }
>
> </PerlEvangelism>
>
> This connected, built a cursor, read it and searched it.
>
> Compare to how many lines of PL/SQL this would take.
>
> Good reason to learn Perl? :)
>
> Jared
>
>
>
>
>
> rick_stephenso
> [EMAIL PROTECTED] To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> [EMAIL PROTECTED] Subject: Searching across
> multiple columns
> om
>
>
> 10/01/01 11:55
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Does Oracle have a way to do a search across multiple columns/tables for
> specific data? I know I can issue a query with a bunch of or statements,
> but is there something similar to fulltext searching?
>
> Thanks for the information,
>
> Rick Stephenson
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
