I would be at anyone's mercy if they could do this for me.
1. Create a sequence DeptCodeSeq to generate dept codes in the range
1000, 1020, 1040, . .., 9080
Create table called Departments that has the following columns in it.
DeptCode
Name
DeptSize
NUMBER(4)
VARCHAR2(30)
NUMBER(5)
Create a PL/SQL anonymous block called POPDEPTS.sql (Populate Department )
using FOR .. LOOP that uses the DeptCodeSeq to generate the department code
and the name
Where the name is constructed as DEPT-1020 DEPT-1040, and so on. That is the
name of the department is the concatenation of "DEPT-" and the department
code generated by the sequence. As each row is inserted print out the
department t code and department name delimited by ';' on a separate line. (
use the DBMS_OUTPUT.PUT_LINE ).
When testing your code you may need to constantly drop your sequence and
create it until your PL/SQL block works correctly.
DECLARE
.............
............
BEGIN
Your code goes here
( you need FOR .. LOOP statement )
END;
2. Create a PL/SQL block to delete from Departments the departments
that have their name ending in 40 and 80 digits.
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
