Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL [closed]

Tags:

postgresql

oracle

plsql

plpgsql

translation

Is there a tool (preferably free) which will translate Oracle's PL/SQL stored procedure language into Postgresql's PL/pgSQL stored procedure language?

like image 433
dacracot Avatar asked Oct 01 '08 15:10

dacracot

People also ask

Can we use PL SQL in PostgreSQL?

PL/pgSQL is easy to learn and simple to use. PL/pgSQL comes with PostgreSQL by default. The user-defined functions and stored procedures developed in PL/pgSQL can be used like any built-in functions and stored procedures. PL/pgSQL inherits all user-defined types, functions, and operators.

How do I write a PL SQL program in PostgreSQL?

Introduction. PL/pgSQL (Procedural Language/PostgreSQL) is a loadable procedural programming language supported by the PostgreSQL. PL/pgSQL, as a fully featured programming language, allows much more procedural control than SQL, including the ability to use loops and other control structures.

Is PL SQL and PostgreSQL same?

This section explains differences between PostgreSQL's PL/pgSQL language and Oracle's PL/SQL language, to help developers who port applications from Oracle® to PostgreSQL. PL/pgSQL is similar to PL/SQL in many aspects. It is a block-structured, imperative language, and all variables have to be declared.

1 Answers

There is a tool available at http://ora2pg.darold.net/ which can be used to transalate Oracle Schemas to Postgres schemas, but I'm not sure if it will also translate the stored procedures. But it might provide a place to start.

like image 103
Jimoc Avatar answered Oct 27 '22 02:10

Jimoc
Sign in to Comment

Related questions

Numbering of groups in select (Oracle)
Join to an oracle table valued function
Use Alias in Select Query
view all data for duplicate rows in oracle
Oracle Rolling or Running totals by month
Use gv$session to tell if a query is hanging
What is the simplest way to define a local variable in Oracle?
Which data type is used to store DateTime in Oracle 10g?
Issue when comparing result of to_char(myDate, 'DAY') to a string
ALTER statement: Why VARCHAR2(50 BYTE) instead of VARCHAR2(50 CHAR)? [duplicate]
How to conditionally select a column in an Oracle query
JBoss EAP 6.x with Hibernate Oracle Sequence Duplicate Value on Primary Key
Insert multiple rows into a table with only one value changing
SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed
using EXECUTE IMMEDIATE with multiple same bind arguments
Copy a column to another column within a same table in oracle db. Do I need to specify which data goes where?
Remove simple HTML-Tags from String in Oracle via RegExp, Explanation needed
Oracle SQL Developer doesn't start
Disable all foreign key constraints associated to specific table
JDBC Stream of CLOB in Oracle 12.2 database gives wrong encoding

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!