Re: Foreign key in Oracle Sql

"-CELKO-" <jcelko212_at_earthlink.net> wrote in message news:1105729768.950077.303140_at_f14g2000cwb.googlegroups.com...
> >> What are the right data types? <<
>
> See SQL Standards for the list. There is no VARCHAR2() or NUMBER(),
> NULLs propagate in strings, there are both FLOAT and REAL, etc.

All I was doing was asking for information, not starting an argument. What are the standard data types? And are you saying that data types that are not in the standard should be desupported?

( BTW, I like NUMBER. I don't like VARCHAR2. Not that it makes any difference)

What does NULLs propagate in strings mean? something like ANY_STRING || NULL yields NULL?
Tell me more about FLOAT and REAL.

>
> >> How do you tell the difference between a file system with a fancy
> front end,
> and a real engine? <<
>
> Do you have operations that expose a physical ordering in the storage,
> such as the row number? Can you do subqueries? Is there an
> optimizer?
>

Operations that expose a physical ordering: bad idea, agreed. But you don't have to use them, do you?
Subqueries: I take it you mean incomplete support for SQL. If so, agreed. No Optimizer: As you know, if you know me, I really, really like a good optimizer. So, in terms of "goodness" I rate the quality of the optimizer very highly. But an optimizer is a "good feature", not a "relational feature". A real engine minus the optimizier is still a real engine. Just real slow. Received on Sat Jan 15 2005 - 06:11:46 CET