PL/SQL

Create Cursor FOR Loop

Page 1 of 1

1 Replies - 1499 Views - Last Post: 20 October 2006 - 06:00 PM 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 20 October 2006 - 12:41 PM

How would go about creating a cursor FOR loop for the following:

a. Retrieve the id, firstname, and lastname of the employee who lives in Chicago

b. Insert that employee's id, firstname and lastname into a temp table, that you will create.

c. The temp table can have whatever column names you decide, but must include the id, firstname, and lastname of the employee who lives in Chicago.

I just need help getting this started.

THANKS

Is This A Good Question/Topic? 0
  • +

Replies To: PL/SQL

#2 rockstar_  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 32
  • View blog
  • Posts: 189
  • Joined: 16-October 06

Re: PL/SQL

Posted 20 October 2006 - 06:00 PM

View Postcswtsjaij, on 20 Oct, 2006 - 12:41 PM, said:

c. The temp table can have whatever column names you decide, but must include the id, firstname, and lastname of the employee who lives in Chicago.

May I ask why you'd like to create a temporary table? What's the implementation for it? I currently am experiencing growing pains in a web application I work on. Temporary tables, as databases get larger, cause the most HELLACIOUS overhead. In fact, I've got a few MySQL experts completely stumped on how to remedy this situation.

And so I ask why because I'm trying to get away from them, and you're trying to make one.

rockstar_
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1