Re: 2 Oracle doubts

Quarkman <quarkman_at_myrealbox.com> wrote in message news:<oprsuxo1o5r9lm4d_at_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.)
 

   I have a table in my datamodel that really don´t have a primary key. This table stores the data of anonymous polls. One record only have the data of the poll, this data can exists duplicate a lot of times. The table have a foreing key (the id of office that realize the poll). This table haven´t any details tables.

>
> > 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 Sun Jul 27 2003 - 13:32:12 CDT