I cloned it in postgres on a porting project awhile back.

However, it is not only Oracle specific, but in most cases it is EVIL since people abuse it to get out of creating reference tables.