Is this a homework assignment or a spec? Anyway, send me full details off-list and I'll give you a timeline and my rate.
On Sun, 21 Apr 2002, Joshua Tipton wrote: > 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. > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
