Why not try number 1 yourself. It would take less effort than posting the
question. As for number 2 , no dates are not strings they are dates.(RTFM)
In sqlPlus etc. you will see the output of a date represented as a string
and this is what confuses people. (same with numbers, what is onthe screen
is a string representation of the number not the number, a lotof people put
in a high percision number inthe back end, doa select in sqlPlus and think
that Oracle has rounded the number- it has not - the display of a number was
rounded). In Oracle dates have a time component whether you specify it or
not when you put it in there. If you do not specify the time component it
assumes midnight. So if all the dates are at midnight then you can easily
do an equality with a date (in the database) and a string constant converted
to a date (see manual, sql reference to_date function). However , if the
dates are not all at midnight then you must specify the time in the string
constant converted to a date or do a range. (eg everything from midnight of
this date to just before midnight of that date)
Jim
"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!
Received on Fri Jul 25 2003 - 09:43:58 CDT
