[cswtsjaij]

Hello,

Can someone HELP me. I have to create an Anonymous Block from the following:

create an anonymous PL/SQL block,
a. Include records for one employee who lives in Delaware
b. Retrieve the id, firstname, and lastname of the employee who lives in Delaware
c. Include an exception section to handle whatever error you chose.

I am taking a class and the example in the book does not help at all. Can some one get me started on how to create an anonymous block?

THANKS

[gregoryH]

cswtsjaij, on 17 Oct, 2006 - 01:30 PM, said:

Hello,

Can someone HELP me. I have to create an Anonymous Block from the following:

create an anonymous PL/SQL block,
a. Include records for one employee who lives in Delaware
b. Retrieve the id, firstname, and lastname of the employee who lives in Delaware
c. Include an exception section to handle whatever error you chose.

I am taking a class and the example in the book does not help at all. Can some one get me started on how to create an anonymous block?

THANKS

Hi

I think you should post some SQL so we can guide you first...