Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
azforlife
Starting Member
1 Post |
 Posted - 2008-04-08 : 02:37:01
|
| I've written a couple blocks but I have no idea when it comes to this one.Create a PL/SQL block to retrieve the last name and department ID if each employee from the EMPLOYEES tablefor those employees whose EMPLOYEE_ID is less than 114. From the values retreived from the employees table, populate two PL/SQL tables, one to store the records of the employee last names and the other to store the records of their department IDs. Using a loop, retreive the employee name information and salary infromation from the PL/SQL tables and doisplay it in the window, using DBMS_OUTPUT.PUT_LINE. Display these details for the first 15 employees in the PL/SQL tables.Any help helps |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-04-08 : 02:40:27
|
| First of all this reeeeeally sounds like homework so you should look it up in one of your books. Second, this is a forum for MS SQL Server so you'd be better off trying some of the oracle forums over at dbforums.com or something...--Lumbago |
 |
|
|
|
|
|
Pl/Sql block?