In article <oprsuxo1o5r9lm4d_at_haydn>, Quarkman <quarkman_at_myrealbox.com> wrote:
>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
>
alot of packaged apps do not have any keys on thier oracle tables, they do it
all interanally. usually it is to hinder reverse engineering of their apps,
having all the relational stuff in the tables gives insight into design. I
have seen the internal tables of a very well known and expensive enterprise
package. no keys, tables and columns have almost nonsense names (and in a
language other than english)
Received on Fri Aug 08 2003 - 09:35:16 CDT
