Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Foreign key in Oracle Sql

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@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 - 13:09:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US