安塞俩穆阿拉昆~~

这是一条我经常写的典型Sequence：CREATE SEQUENCE SDOP_COC_ID Increment by 1 start with 1 minvalue 1 maxvalue 9999999999 cycle nocache order;语法很简单，可以参考这个图：[img]http://www.lorentzcenter.nl/awcourse/oracle/se...

今天碰到一个问题，同一张表里的两个字段：to_port, from_port，都作为另外一个表airport的外键。Visio居然在generate SQL的时候报错：error L3020: Foreign key relationship has same parent and child tables as TDOP_AIRPORT_ET_FK2, but does not have d...

oracle的联机文档描述了analyze的做用：Use the ANALYZE statement to collect non-optimizer statistics, for example, to:Collect or delete statistics about an index or index partition, table or table partition, ...

Oracle数据类型简单总结，适用于7, 8 & 9ihttp://www.ss64.com/orasyntax/datatypes.html :D