Differences

This shows you the differences between two versions of the page.

plsql-to-java [January 20, 2018 5:04 am]
sqlines
plsql-to-java [May 06, 2021 4:18 am] (current)
sqlines
Line 1: Line 1:
====== Oracle PL/SQL to Java Migration ====== ====== Oracle PL/SQL to Java Migration ======
-SQLines open source tools can help you convert Oracle PL/SQL stored procedures, functions and packages to Java.+SQLines provides tools to help you convert Oracle PL/SQL stored procedures, functions and packages to Java.
-===== SQLines Tools =====+<code> 
 +  ./sqlines -s=oracle -t=oracle -tl=java -in=package.sql  
 +</code>
-You can use SQLines SQL Converter tool to convert Oracle PL/SQL to Java. Currently the conversion is available in the command line only: 
-| sqlines -tl=java -s=oracle -t=oracle -in=package.sql | 
===== Migration Reference ===== ===== Migration Reference =====
Line 16: Line 16:
  * [[/plsql-to-java#create-package-statement|CREATE PACKAGE]]   * [[/plsql-to-java#create-package-statement|CREATE PACKAGE]]
  * [[/plsql-to-java#plsql-statements|PL/SQL Statements]]   * [[/plsql-to-java#plsql-statements|PL/SQL Statements]]
 +  * [[/plsql-to-java#built-in-plsql-packages|Built-in PL/SQL Packages]]
===== Language Elements ===== ===== Language Elements =====
Line 22: Line 23:
| | **PL/SQL** || **Java** || | | **PL/SQL** || **Java** ||
-| 1 | NULL | NULL value | null | Null reference | +| 1 | '//string_literal//' | String literals in single quotes | %%"%%//string_literal//%%"%% | String literals in double quotes |  
-| 2 | //expr// IS NULL | Check for NULL value | //expr// == null ||+| 2 | %%||%% Operator | String concatenation | + Operator ||  
 +| 3 | NULL | NULL value | null | Null reference | 
 +| 4 | //expr// IS NULL | Check for NULL value | //expr// == null ||
Derived data types: Derived data types:
Line 115: Line 118:
| 1 | COMMIT | Commit the transaction | conn.commit(); | | 1 | COMMIT | Commit the transaction | conn.commit(); |
 +===== Built-in PL/SQL Packages =====
 +Converting built-in PL/SQL packages:
 +
 +| | **Oracle** || **Java** |
 +| 1 | DBMS_OUTPUT.PUT_LINE(//text//) | Output a message | System.out.println(//text//) |