Re: Foreign key in Oracle Sql
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 14 Jan 2005 11:09:28 -0800
Message-ID: <1105729768.950077.303140_at_f14g2000cwb.googlegroups.com>
Date: 14 Jan 2005 11:09:28 -0800
Message-ID: <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.
>> 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? Received on Fri Jan 14 2005 - 20:09:28 CET