Postgres to Oracle

[Saii]

what is the equivalent of CREATE CAST and CREATE AGGREGATE in Oracle, if any?

[rski]

For aggregates you can look here
http://download-uk.oracle.com/docs/c...5/dci11agg.htm,
I don't know anything about CAST in oracle (if you found any info about that please share you knowledge here)