Re: 2 Oracle doubts

From: Quarkman <quarkman_at_myrealbox.com>
Date: Fri, 25 Jul 2003 18:25:39 +1000
Message-ID: <oprsuxo1o5r9lm4d@haydn>

On 25 Jul 2003 01:16:17 -0700, delavega <delapordio_at_hotmail.com> wrote:

> Hi. I´m a MySql programmer, but i need make a application with Oracle
> 8.1 Server. I have 2 doubts (for the moment)
>
> 1-Can i have a Oracle table without primary Key?

Yes. But this is a *relational* database, so why you'd actually want this I can't really imagine (OK, I've seen heaps of bad applications who wouldn't know a primary key from a prune, but they're really *bad* apps.)

> 2-In a sql, the date fields are with quotas ("")? Exists the
> direct comparation between dates (<, >)?

Get thyself to tahiti.oracle.com and start reading the documentation on issues like this. Short answer: dates need a fair bit of manipulation, but yes you can do maths with them.

~QM Received on Fri Jul 25 2003 - 03:25:39 CDT