Oracle Newbie (coupla quick ones!)

From: ed <tinman_x_at_hotmail.com>
Date: Mon, 14 Feb 2000 15:55:14 +0800
Message-ID: <38a7b746$0$32620@motown.iinet.net.au>

Hi all,
I have a couple of quick questions. I use Oracle 8.1.5, with vb6, connected using the Oracle ODBC driver through ADO. Cool, this SEEMS to work, however, I have a couple of questions/issues.

a.Oracle date format in SQL Strings
What is the format required to save a date AND time into an Oracle DB? We know dd-MMM-yyyy will save date, but what about time??? I tried dd-MMM-yyyy hh:nn, but this fails. Also, do you need the to_date function?

b.Joining tables (outer joins)
I want ALL rows from tblname1, and only matching rows from tblname2 I have seen 2 different ways to do this. Which is the RIGHT way? 1.tblname1.keyfield(+) = tblname2.fkeyfield 2.tblname1.keyfield *= tblname2.fkeyfield Also, does this have to be done with a where clause? (rather than 'inner join') I get syntax errors with the 'inner join' command.

Thanks in advance...
Ed. Received on Mon Feb 14 2000 - 01:55:14 CST