Hi Nick,
Try something like this:
SELECT *
FROM people
WHERE UPPER(lname) LIKE '%OFF%';
Good luck.
-John
-Original Message-
From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 3:06 PM
To: DBI-Users
Subject: case-insensitivity in Access
Hey. I'm
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:24 PM
To: Guidarelli, John; 'DBI Users'
Subject: Re: DBD::Oracle - specifying rollback segments
On Tue, 30 Jul 2002 12:50:25 -0700 "Guidarelli, John"
<[EMAIL PROTECTE
Hello,
Is there anyway to specify the rollback segment to use in Oracle via the
DBD::Oracle module?
I did not see anything in the DBD::Oracle or DBI perldocs other than the
begin_work DBH Object (which doesn't take any parameters).
Thanks in advance.
-John
Does anyone out there know if there is way to get the column names/types for
a given table using the DBD::Oracle driver?
I looking for something like the DESCRIBE SQL*Plus command.
Thanks in advance.
-John