Re: open cursor

"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message news:UOusd.716526$8_6.645904_at_attbi_s04...
> Does open cursor in plsql execute the SQL ?
>
> cursor c is
> select x, y from z ;
> begin
> open c;
>
>

answering my own question ...
 Opening a Cursor
Opening the cursor executes the query and identifies the result set, which consists of all rows that meet the query search criteria. For cursors declared using the FOR UPDATE clause, the OPEN statement also locks those rows. An example of the OPEN statement follows: Received on Sat Dec 04 2004 - 21:19:13 CST