At 09:52 AM 3/22/01 -0500, Brooks, Ken wrote:
>Lets start at the basics.
>
>What is the easiest way to *make sure* that i am connecting to that oracle
>db?
>
>Anyway I can just list the tables, or something.
>odbc_tables or something like that?..
To get a list of the tables, you could:
SELECT TABLE_NAME FROM ALL_TABLES;
...but, since you're on Oracle anyway, why not do something even quicker?
SELECT SYSDATE FROM DUAL;
will return the current date.
SELECT TO_CHAR(SYSDATE,'DD-MON-YY HH24:MI:SS') FROM DUAL;
will return the current date and time.
- Brian
-------------------------------------
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
<[EMAIL PROTECTED]>
-------------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
