https://sqlines.com/ 2026-04-23T22:29:21+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2023-01-01T16:25:48+00:00 https://sqlines.com/plsql-to-java/delete?rev=1672590348&do=diff In Oracle PL/SQL you can use the DELETE statement to delete one or more rows in a table. In Java JDBC you have to use the prepared statements: Oracle: -- Procedure that deletes rows from table CREATE OR REPLACE PROCEDURE sp_deleteCity(p_name VARCHAR2) AS BEGIN DELETE FROM cities WHERE name_upper = UPPER(p_name) OR name = p_name; END; / text/html 2022-11-18T20:29:36+00:00 https://sqlines.com/plsql-to-java/for_cursor_loop?rev=1668803376&do=diff In Oracle PL/SQL you can use the FOR loop statement to open a cursor and fetch rows. In Java JDBC you can open ResultSet and use while() statement to iterate rows. Oracle: -- Procedure that fetches rows from a cursor CREATE OR REPLACE PROCEDURE sp_printCities AS CURSOR c1 IS SELECT name FROM cities; BEGIN FOR rec IN c1 LOOP DBMS_OUTPUT.PUT_LINE('City: ' || rec.name); END LOOP; END; / text/html 2022-10-02T21:39:56+00:00 https://sqlines.com/plsql-to-java/insert?rev=1664746796&do=diff In Oracle PL/SQL you can use the INSERT statement to insert rows into a table. In Java JDBC you have to use the prepared statements: Oracle: -- Procedure that inserts a row into table CREATE OR REPLACE PROCEDURE sp_insertCity(name VARCHAR2) AS BEGIN INSERT INTO cities VALUES (name, UPPER(name)); END; / text/html 2022-10-03T20:46:06+00:00 https://sqlines.com/plsql-to-java/select_into?rev=1664829966&do=diff In Oracle PL/SQL you can SELECT INTO statement to read exactly one row and assign values of the selected columns to variables. In Java JDBC you have to use the prepared statements: Oracle: -- Procedure with SELECT INTO statements CREATE OR REPLACE PROCEDURE sp_processCity(p_name VARCHAR2) AS cnt NUMBER; v_name VARCHAR2(30); v_name_upper VARCHAR2(30); BEGIN SELECT COUNT(*) INTO cnt FROM cities WHERE name = p_name; SELECT name, name_upper I… text/html 2024-06-27T18:12:13+00:00 https://sqlines.com/plsql-to-java/type_record?rev=1719511933&do=diff In Oracle PL/SQL you can declare a record (structure) with specified variables. In Java you can use a plain class with getter and setter methods: Oracle: CREATE OR REPLACE PACKAGE name AS TYPE item IS RECORD ( name VARCHAR2(100), desc VARCHAR2(100), notes VARCHAR2(100), ); END; / text/html 2023-01-01T16:22:32+00:00 https://sqlines.com/plsql-to-java/update?rev=1672590152&do=diff In Oracle PL/SQL you can use the UPDATE statement to update one or more rows in a table. In Java JDBC you have to use the prepared statements: Oracle: -- Procedure that updates a table CREATE OR REPLACE PROCEDURE sp_updateCity(p_name VARCHAR2) AS BEGIN UPDATE cities SET name_upper = UPPER(p_name) WHERE name = p_name; END; /