PL/SQL

Create Anonymous Block

Page 1 of 1

1 Replies - 1855 Views - Last Post: 02 November 2006 - 01:39 AM Rate Topic: -----

#1 cswtsjaij  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 30-June 06

PL/SQL

Posted 17 October 2006 - 01:30 PM

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

Is This A Good Question/Topic? 0
  • +

Replies To: PL/SQL

#2 gregoryH  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 60
  • View blog
  • Posts: 656
  • Joined: 04-October 06

Re: PL/SQL

Posted 02 November 2006 - 01:39 AM

View Postcswtsjaij, 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...
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1