Skip to content

Tag: navicat

Escape semi colon in “CREATE OR REPLACE AND COMPILE JAVA” statement

I’m trying to execute the following statement in Navicat, But since ; is treated as a delimiter in SQL query, the query became “incomplete” and results in an error: So how can I execute this statement in Navicat? Answer Store the command as a string and dynamically execute it with an anonymous PL/SQL block: Not many Oracle IDEs understand the