Sitemap

Member-only story

PL/SQL architecture

Sep 24, 2025

--

PL/SQL is a block structure programming language.Which is having the following two engine these are-

Press enter or click to view image in full size

1-SQL Engine-whenever we are submitting a PL/SQL block into a oracle server then all SQL quries are separated and executed by SQL query executor within SQL engine.

SQL query are sending to the SQL engine and SQL engine,SQL code send to the SQL query executor and SQL query executor it will be compiled and executing your SQL related queries.

2-PL/SQL Engine-whenever we are submitting a PL/SQL block into a oracle server then all PL/SQL code or statement are separated and executed by PL/SQL code executor within a PL/SQL engine.

In PL/SQL engine,PL/SQL code separated and SQL related queries are separated means PL/SQL engine it will be separating two languages of code.

PL/SQL code executor it will compiled and execute PL/SQL related code.

--

--