RE: Oracle Gurus
are you out of your mind? pick up an oracle book. at the least you should offer dinner to the nice coder who is willing to help you. alex -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 6:59 PM To: CF-Talk Subject: Oracle Gurus 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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Re: Oracle Gurus
Joshua Tipton wrote: I would be at anyone's mercy if they could do this for me. If I understand your questions correctly you are currently at the mercy of your teacher. What makes you believe that being at the mercy of just anybody would be any better? Jochem __ 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
RE: Oracle Gurus
ok... i'll help a little. a search for 'oracle sequence' at google spits out http://members.tripod.com/mdameryk/CreateSequence.htm as the first hit. now your well on your way. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 6:59 PM To: CF-Talk Subject: Oracle Gurus 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Gurus
I think you would do better to offer money than mercy. -Matt -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 3:59 PM To: CF-Talk Subject: Oracle Gurus 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. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: Oracle Gurus
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Gurus
I already have the create table and create sequence part complete I just actually need help with the insert part. I have never worked with a sequence. I have this much can anyone tell me if I am heading in the right direction and if so feel free to throw in any thing to help put me in the correct direction. CREATE SEQUENCE DeptCodeSeq INCREMENT BY 20 START WITH 1000 MAXVALUE 9080 NOCYCLE; CREATE TABLE Departments (DeptCode NUMBER(4), Name VARCHAR2(30), DeptSize NUMBER(5)); DECLARE V_DeptCode DeptCodeSeq.nextval%type; v_Name varchar2(30); v_DeptSize number(5); BEGIN END -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 6:59 PM To: CF-Talk Subject: Oracle Gurus 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