Oracle 8 generating own Field Types

Somewhere I read that I can create Domains in SQL which could be used as

Can Someone tell me if there is really a possibility to create own
Fieldtypes in Oracle 8
and can I use this Fieldtypes in Delphi and BDE 5.01 ?