2

I want to know if oracle style object oriented database code can be written in mysql, postgresql or any OSS database softwares. I don't want to install the massive oracle db on my ubuntu to learn minimum database programming

EDIT1: After installing orafce when I did the following

CREATE TYPE addr_obj_typ AS OBJECT (
    street          VARCHAR2(30),
    city            VARCHAR2(20),
    state           CHAR(2),
    zip             NUMBER(5));

And I got this error:

ERROR:  syntax error at or near "object"
LINE 1: create type addr_obj_typ as object

1 Answer 1

3

Postgres is probably closest to Oracle, especially if you install the Oracle support functions for PostgreSQL

sudo apt-get install postgresql-8.4-orafce

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .