Postgresql to Oracle migration issues

Hello,

I want to migrate to Oracle from the opensource database Postgresql.

There are a couple of features of postgresql my application is depending on and it
would require large amount of code rewriting if not provided by Oracle.

1. Datatypes

Postgresql provides a "money" datatype wich outputs formatted money string.
In oracle I can convert number to strings witch a format but how can I do it automatically for
a particular colum (based on its datatype). Should I use views ?

Postgresql provides an API for writing modules. I have implemented a
"percent" type

and some operators (+,*,...) and a "internal<->string" conversion function.
I have seen something on user datatypes in oracle but I've seen nothing that can
implement such a conversion between the object (datatype) and the output string
(the select statement. For example "select a,b,c from mytable" ->
"blabla | 2 % | 3 Kn "

if 'b' is of type 'percent')
In oracle object types cannot be output by a 'select'.

Is there a way to implement extended types in oracle (written in C) ?

Slavica Stefic Received on Tue Feb 27 2001 - 19:55:28 CST