Porting from Oracle to PostgreSQL

  • Ora2pg -a Perl module to export an Oracle database schema to a PostgreSQL compatible schema
  • Orafce -implemente some functions from Oracle database next_day, last_day, trunc, round, DBMS_ALERT, DBMS_OUTPUT, UTL_FILE, DBMS_PIPE, ...
  • PL/pgSQL -PL/pgSQL is a loadable, procedural language, similar to the Oracle procedural language, PL/SQL.
  • PL/Java - brings JavaTM Stored Procedures, Triggers, and Functions to the PostgreSQL