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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists