OT: RANT ABOUT OCP, Re: Small help
Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: RANT ABOUT OCP, Re: Small help
ooh goodie, now I don't have to do my OCP rant, you've done it for me :) Joe, tell us how you REALLY feel, okay? From: "Joseph S. Testa" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 04:05:54 -0800 Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: RANT ABOUT OCP, Re: Small help
Anyone who's watched the list for a week will know me, no political correctness here :) and thats probably the only reason i am OCP, the company i worked for at the time, paid for the tests and gave me a bonus to complete them. :) joe From: "Thater, William" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 05:00:25 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id IAA04008for jtestamail@localhost; Thu, 29 Mar 2001 08:36:51 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Thu, 29 Mar 2001 08:36:56 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2TEbEl28072for [EMAIL PROTECTED]; Thu, 29 Mar 2001 08:37:14 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA15519;Thu, 29 Mar 2001 05:24:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DB44A; Thu, 29 Mar 2001 05:00:25 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Thater, William" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: RANT ABOUT OCP, Re: Small help
Same with me. And as budgets dwindled, I stopped after getting my 'shingle' for Ora8 (upgrade, that is).. - Kirti -Original Message- From: Joseph Testa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 8:06 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: RANT ABOUT OCP, Re: Small help Anyone who's watched the list for a week will know me, no political correctness here :) and thats probably the only reason i am OCP, the company i worked for at the time, paid for the tests and gave me a bonus to complete them. :) joe From: "Thater, William" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 05:00:25 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id IAA04008for jtestamail@localhost; Thu, 29 Mar 2001 08:36:51 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Thu, 29 Mar 2001 08:36:56 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2TEbEl28072for [EMAIL PROTECTED]; Thu, 29 Mar 2001 08:37:14 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA15519;Thu, 29 Mar 2001 05:24:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DB44A; Thu, 29 Mar 2001 05:00:25 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Thater, William" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: OT: RANT ABOUT OCP, Re: Small help
Xing, Your OCP course may mention the script (depends which course you plan to take), but they will only mention it quickly. You can look it up in the Oracle administration manuals, or in the O'Reilly Oracle Built-In Packages book. Basically it generates statistics for the optimizer within a given schema. The OCP course will give you a basic overview of what Oracle can do and what all its parts are, but it won't give you enough info to administer databases properly. It's a good starting point, though -- you will have been exposed to an overview of what it is all about. To learn to administer Oracle, you MUST have a test instance to "play" with to try different things. At the same time, try to get exposure to it with people who are doing that work. With a test DB you could look up the procedure, then say "I wonder what it really does" and try it on your own instance, then notice what happens. To administer Oracle you must have an understanding of how it works, but also you need experience with it because the courses and the manuals don't tell you everything. Some of it is trial and error, getting bruised, etc. etc. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Subject: Re:OT: RANT ABOUT OCP, Re: Small help Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list,
Re: OT: RANT ABOUT OCP, Re: Small help
Well done Bill...nicely handled...gotta remember that one! [EMAIL PROTECTED] 03/29/01 08:00AM "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: RANT ABOUT OCP, Re: Small help
I'll be the first to admit that sometimes I ask a question when I should probably look up the answer, but is it just me, or do about half the messages on the list seem like they could be answered in about 5 minutes by typing the question into google or RTFM. I mean seriously, I was running into issues installing 8.1.5 on Solaris 2.6 x86 and until I worked all the way through the install instructions, I had issues. In the process, I learned a boatload about Solaris and Oracle. No, I'm not slamming anyone who asks simple questions, some things aren't worth the time to research. Kind of like when someone asks for help with a regexp in a shell script. Are we going to tell that person they should become a script guru? No, a quick help is very appropriate. The questions like "How do I install 8.X.X on Linux" or "How do I become a DBA", those are the questions that frost me because they imply a complete lack of effort expended. On the other hand, if someone says, "I read through the docs and this site and that site, but because I'm still new, I don't understand how the Log writer works, can someone explain it?", that's a person I feel good about helping. Dan "growl" -Original Message- Sent: Thursday, March 29, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re[2]:OT: RANT ABOUT OCP, Re: Small help
Cherie, OK, point well taken, so "silver bullet" would translate into "the one item that will succeed when no other does", "magic formula". And, no he never did say he had an OCP, but he did say he was taking a "course" to get his OCP. To me having an OCP certificate without any experience is totally meaningless. All it tells me is that you can memorize information and take a test. It does not tell me that you'll hold up in a crisis or that you really understand the consequences of your actions. That experience speaks volumes more. Now someone with a number of years experience AND an OCP certificate is a different matter altogether. Consequently my question, are new people looking at the OCP as the gateway into a position that they could not otherwise get? BTW: I'm not trying to either criticize or "brow beat" Xing. If that impression has been left, then I apologize. He asked a question, similar ones I field in house each day, and he was given an answer that is similar to the ones I hand out to my developers although I'd have given him the page number too and a whole lot less trash than Xing has gotten from this list. In my mind that is sufficient to the purpose. Now if that creates additional questions, a much longer dissertation on the results is in order. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/29/2001 6:35 AM Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
Re: OT: RANT ABOUT OCP, Re: Small help
I think what Lee's objection was (I know when I read Xing's reply it got my goat), that Xing critized Lee for giving him a referance to look the answer up himself. I realize that it did not answer in full the actual question, but it asked Xing to do a little work on his own. If someone taking a course or studying to pass the OCP exams can not do a little work themselves, they are not cut out to be a DBA. Terry [EMAIL PROTECTED] wrote: Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services