Here is how I do it ...
[REF PHP PAGE]
?php
$conn=include(conn.php);
?
. HTMl CODE HERE .
?php
$qry=SELECT lower(instance) instance FROM all_databases ORDER BY
instance;
$cursor=ora_open($conn);
ora_parse($cursor,$qry,0);
ora_exec($cursor);
I just wanted to add my two cents ...
I have compiled php with BOTH --with-oracle and --with-oci8. It is
usually preferred to have your architectures/systems separate to prevent
some performance issues. As a test/demo system then having them on the
same box is perfectly acceptable and
In Oracle you have a couple of choices.
(1) If you can ensure that the data stored is in one case you can apply a
function to the keyed in data
SELECT item_number FROM item WHERE item_code = lower('M1234');
(2) If you can not ensure data case then you can apply the function to
both
As an Oracle DBA (9+ years, versions 7.x - 9.x) I just wanted to make a
correction. The LIKE command uses wild card characters ( _ and % ) for
substitutions. Oracle IS a case-sensitive RDBMS and the LIKE command will
NOT do case-insensitive queries.
Roy A. Jones
US Pharma Database
Return Receipt
Your Re: [PHP-DB] help newbie
document
:
