Re: 2 Oracle doubts

Forgive me if I repeat an answer someone else already gave - too long a thread to read the whole thing ...

1 - Yes. However, in most cases, you should want a primary key.

2 - Once you insert a value into a date datatype, it can be compared all kinds of ways no matter how it gets entered (yes, using < and > are 2 of the many potential comparison examples). It can also be displayed later all kinds of ways. Also, you can enter a value into date datatype in several ways such as a copy of another date datatype column, by inserting a string in the default date format, and by using the to_date function on a literal using a format mask which allows entering literal dates in all kinds of formats.

-- 
"delavega" <delapordio_at_hotmail.com> wrote in message
news:42d54ae4.0307250016.679a412b_at_posting.google.com...


> 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?

>    2- In a sql, the date fields are with quotas ("")? Exists the

> direct comparation between dates (<, >)?

>

>    Thanks!