PL/SQL engine in SQLDeveloper

Is there a PL/SQL engine i开发者_运维技巧n SQLDeveloper?

You can run PL/SQL in SQL Developer just as you can in SQL*Plus. I'd say the 'engine' is in the database though, not in the client.

SQLDeveloper is a Java application that connects to your Oracle database schema through JDBC, it does not have, or even needs, its own PL/SQL engine.

No,SQLDeveloper does not have a PL/SQL engine embedded in it.

You login to an oracle DB, author your PL/SQL procs and tell OracleDB to execute/debug them. That's all.

SQL Developer can run PL/SQL code.

Wrap the PL/SQL code in BEGIN & END and it will run fine

Oracle Forms and Reports use their own PL/SQL engines. Although syntactically they are identical, they are not the same as the database engine and uses a different set of libraries. Not all the advanced features of the database engine are available to the Forms and Reports PL/SQL engines and vice versa.

SQLDeveloper is a Java application that acts as a pure JDBC client to an Oracle database; therefore it is not a PLSQL interpreter(engine) by itself, but in case you were wondering where the syntax validation messages were coming from in the GUI, it does ship with a SQL/PLSQL parser generated in Java using Antlr (http://www.antlr.org/about.html) from a custom SQL/PLSQL grammar.