Re: OCP Question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 27 Nov 1999 01:51:20 GMT
Message-ID: <384d37be.63267070@netnews.worldnet.att.net>

Wesley,

You really should dig through the manuals for the answer to this question. You can probably deduce the answer if you think about what Pl/SQL is. It's a procedural language. Given that PL/SQL is procedural, could you really group all the SQL statements from a PL/SQL block and execute them out of order from the rest of the code? Probably not. As for whether they go to the SQL Executor or the PL/SQL Executor, look in chapter 17 of the Oracle Concepts Manual.

BTW if you are studying for your OCP exam, I highly recommend reading through the concepts manual. It's well done, an explains a lot about how Oracle works.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Fri, 26 Nov 1999 07:39:13 GMT, Wesley <wesleyto_at_my-deja.com> wrote:

>Does anybody know the answer of the following:
>
>How does the PL/SQL engine process SQL statements?
>
> a. Groups SQL statements and sends them to the PL/SQL
>statement executor
> b. Groups SQL statements and sends them to the SQL
>statement executor
> c. Separates SQL statements and sends them to the PL/SQL
>statement executor
> d. Separates SQL statements and sends them to the SQL
>statement executor
> e. none of the above
>
>TIA.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Nov 26 1999 - 19:51:20 CST