Member-only story
PL/SQL architecture
PL/SQL is a block structure programming language.Which is having the following two engine these are-
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.








