Re: 2 Oracle doubts

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Fri, 25 Jul 2003 09:18:08 GMT
Message-ID: <3F20F3E9.1C61A0@telusplanet.net>

delavega 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. (However, this would make me doubt the design & the experience of the designer.)

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

What is a 'sql'? Do you mean a SQL statement (like select) or an environment or are you referring to something specific from MySql?

You may find the Oracle documentation useful. This can be read at http://otn.oracle.com (click on documentation link on left menu).

Specifically look for the "SQL Reference" or "SQL Language Reference" manual (the name changes between versions) and look at the chapter on 'dates and date functions'.

You might also look through the Concepts Manual to understand how MySQL and Oracle are different. Received on Fri Jul 25 2003 - 04:18:08 CDT