PG's table inheritance and object table in Oracle

Started by David Garamondabout 22 years ago2 messagesgeneral
Jump to latest
#1David Garamond
lists@zara.6.isreserved.com

Is there anyone using object table in Oracle? How does it differ from
table inheritance in PG (aside from the declaration syntax).

I actually just found out about table inheritance today, and absolutely
love it! However, it's a shame if this feature is totally unportable.
Are there any other popular RDBMS carrying the same kind of feature?
(I've checked Oracle 9i, Mimer 9.2, FB 1.5, SQLServer 2k, DB2 8.1...)

--
dave

#2Bruce Momjian
bruce@momjian.us
In reply to: David Garamond (#1)
Re: PG's table inheritance and object table in Oracle

David Garamond wrote:

Is there anyone using object table in Oracle? How does it differ from
table inheritance in PG (aside from the declaration syntax).

I actually just found out about table inheritance today, and absolutely
love it! However, it's a shame if this feature is totally unportable.
Are there any other popular RDBMS carrying the same kind of feature?
(I've checked Oracle 9i, Mimer 9.2, FB 1.5, SQLServer 2k, DB2 8.1...)

I thought the inheritance was in the SQL99 or SQL200X standard, and we
made adjustments a few years ago to match it. See the developers's FAQ
for a link to the standards.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073