Re: OFF TOPIC: RE: PL/SQL
Jared, How about renaming this list into 'DummyDBA'?:) We know already about 'lazydba' list... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 3:10 PM > LoL... > So many opportunities for writing books for all these dummy DBAs !!! LoL.. > > > > -Original Message- > Sent: Tuesday, January 29, 2002 1:15 PM > To: Multiple recipients of list ORACLE-L > > > Kirti, > Good luck!. > > Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro', > '9i Master' (sounds good '9i Dummy OCP' or '9i Dummy OCM', isn't it?:). > I'd love to get '9i' to upgrade my '8i' to '9i' (company doesn't want to pay > for oracle classes/tests:) > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, January 29, 2002 12:35 PM > > > > Igor, > > It's a good night-cap :) > > However, I can use a sign like that, considering what we are going > through > > lately.. Implementing a HUGE system converted to access Oracle RDBMS. > > Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has > 4 > > copy-book routines that are called from the main program (PROCEDURE > > DIVISION) :-) Yes, you guessed it right. I am not joking. > > Today, IBM is on site to fix the performance problems. Hope they find > it > > in the H/W... because they did not code the App. > > Most DBAs are on the side line like dummies!!! > > Installation of this monster will proceed to meet dead lines and, of > course, > > the budget. > > > > Next book on my list -- 'OCP for dummies!' > > > > Cheers ! > > > > - Kirti > > > > -Original Message- > > Sent: Tuesday, January 29, 2002 10:26 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Kirti, > > > > Too much time on your hands? > > > > Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' > > sign? > > > > Igor Neyman, OCP DBA > > [EMAIL PROTECTED] > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Tuesday, January 29, 2002 11:05 AM > > > > > > > Has anyone read 'Oracle8i for Dummies' ?? > > > I have checked it out from our local public library > > > It's not a bad read, I am still in chapter 1, though.. learning some new > & > > > interesting analogies to this techie stuff.. > > > > > > - Kirti > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Deshpande, Kirti > > 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: Igor Neyman > 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: Deshpande, Kirti > 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: Igor Neyman 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 EXAC
Re: OFF TOPIC: RE: PL/SQL
Hi All, Just a funny little story, one day I was interviewing some consultants that had been recommended by a rather large (nameless) consultancy. The administrative assistant indicated that my next interviewee was in the waiting room. As I approached the waiting room I looked throught the blinds and they were reading a DBA for Dummies book. When your resume' says you are "King of the World" and your company wants to charge "Big Bucks" to use you, sitting in the waiting room reading that particular book does not inspire confidence. John [EMAIL PROTECTED] wrote: LoL...So many opportunities for writing books for all these dummy DBAs !!! LoL.. -Original Message-Sent: Tuesday, January 29, 2002 1:15 PMTo: Multiple recipients of list ORACLE-LKirti,Good luck!.Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro','9i Master' (sounds good '9i Dummy OCP' or '9i Dummy OCM', isn't it?:).I'd love to get '9i' to upgrade my '8i' to '9i' (company doesn't want to payfor oracle classes/tests:)Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, January 29, 2002 12:35 PM Igor, It's a good night-cap :) However, I can use a sign like that, considering what we are going through lately.. Implementing a HUGE system converted to access Oracle RDBMS.Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has 4 copy-book routines that are called from the main program (PROCEDUREDIVISION) :-) Yes, you guessed it right. I am not joking.Today, IBM is on site to fix the performance problems. Hope they find it in the H/W... because they did not code the App.Most DBAs are on the side line like dummies!!!Installation of this monster will proceed to meet dead lines and, of course, the budget.Next book on my list -- 'OCP for dummies!'Cheers !- Kirti-Original Message-Sent: Tuesday, January 29, 2002 10:26 AMTo: Multiple recipients of list ORACLE-LKirti,Too much time on your hands?Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA'sign?Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, January 29, 2002 11:05 AM Has anyone read 'Oracle8i for Dummies' ??I have checked it out from our local public libraryIt's not a bad read, I am still in chapter 1, though.. learning some new & interesting analogies to this techie stuff..- Kirti --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Deshpande, Kirti INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OFF TOPIC: RE: PL/SQL
LoL... So many opportunities for writing books for all these dummy DBAs !!! LoL.. -Original Message- Sent: Tuesday, January 29, 2002 1:15 PM To: Multiple recipients of list ORACLE-L Kirti, Good luck!. Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro', '9i Master' (sounds good '9i Dummy OCP' or '9i Dummy OCM', isn't it?:). I'd love to get '9i' to upgrade my '8i' to '9i' (company doesn't want to pay for oracle classes/tests:) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 12:35 PM > Igor, > It's a good night-cap :) > However, I can use a sign like that, considering what we are going through > lately.. Implementing a HUGE system converted to access Oracle RDBMS. > Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has 4 > copy-book routines that are called from the main program (PROCEDURE > DIVISION) :-) Yes, you guessed it right. I am not joking. > Today, IBM is on site to fix the performance problems. Hope they find it > in the H/W... because they did not code the App. > Most DBAs are on the side line like dummies!!! > Installation of this monster will proceed to meet dead lines and, of course, > the budget. > > Next book on my list -- 'OCP for dummies!' > > Cheers ! > > - Kirti > > -Original Message- > Sent: Tuesday, January 29, 2002 10:26 AM > To: Multiple recipients of list ORACLE-L > > > Kirti, > > Too much time on your hands? > > Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' > sign? > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, January 29, 2002 11:05 AM > > > > Has anyone read 'Oracle8i for Dummies' ?? > > I have checked it out from our local public library > > It's not a bad read, I am still in chapter 1, though.. learning some new & > > interesting analogies to this techie stuff.. > > > > - Kirti > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > 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: Igor Neyman 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: Deshpande, Kirti 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: OFF TOPIC: RE: PL/SQL
I also note that Oracle9i for Dummies is now out, according to http://www.dummies.com -Original Message- Sent: Tuesday, January 29, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Will do.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Kirti - I haven't read that book, but I haven't seen a bad book in the "for Dummies" series yet, so I would imagine it is pretty good, especially for beginners. Maybe after you have gone through it you can let us know your opinion, especially whether it is more for beginning Oracle developers or beginning DBAs. Book recommendation is a question that seems to recur on this list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 29, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new & interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L "beginner" should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: OFF TOPIC: RE: PL/SQL
Kirti, Good luck!. Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro', '9i Master' (sounds good '9i Dummy OCP' or '9i Dummy OCM', isn't it?:). I'd love to get '9i' to upgrade my '8i' to '9i' (company doesn't want to pay for oracle classes/tests:) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 12:35 PM > Igor, > It's a good night-cap :) > However, I can use a sign like that, considering what we are going through > lately.. Implementing a HUGE system converted to access Oracle RDBMS. > Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has 4 > copy-book routines that are called from the main program (PROCEDURE > DIVISION) :-) Yes, you guessed it right. I am not joking. > Today, IBM is on site to fix the performance problems. Hope they find it > in the H/W... because they did not code the App. > Most DBAs are on the side line like dummies!!! > Installation of this monster will proceed to meet dead lines and, of course, > the budget. > > Next book on my list -- 'OCP for dummies!' > > Cheers ! > > - Kirti > > -Original Message- > Sent: Tuesday, January 29, 2002 10:26 AM > To: Multiple recipients of list ORACLE-L > > > Kirti, > > Too much time on your hands? > > Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' > sign? > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, January 29, 2002 11:05 AM > > > > Has anyone read 'Oracle8i for Dummies' ?? > > I have checked it out from our local public library > > It's not a bad read, I am still in chapter 1, though.. learning some new & > > interesting analogies to this techie stuff.. > > > > - Kirti > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > 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: Igor Neyman 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: OFF TOPIC: RE: PL/SQL
Will do.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Kirti - I haven't read that book, but I haven't seen a bad book in the "for Dummies" series yet, so I would imagine it is pretty good, especially for beginners. Maybe after you have gone through it you can let us know your opinion, especially whether it is more for beginning Oracle developers or beginning DBAs. Book recommendation is a question that seems to recur on this list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 29, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new & interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L "beginner" should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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 PROT
RE: OFF TOPIC: RE: PL/SQL
Igor, It's a good night-cap :) However, I can use a sign like that, considering what we are going through lately.. Implementing a HUGE system converted to access Oracle RDBMS. Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has 4 copy-book routines that are called from the main program (PROCEDURE DIVISION) :-) Yes, you guessed it right. I am not joking. Today, IBM is on site to fix the performance problems. Hope they find it in the H/W... because they did not code the App. Most DBAs are on the side line like dummies!!! Installation of this monster will proceed to meet dead lines and, of course, the budget. Next book on my list -- 'OCP for dummies!' Cheers ! - Kirti -Original Message- Sent: Tuesday, January 29, 2002 10:26 AM To: Multiple recipients of list ORACLE-L Kirti, Too much time on your hands? Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' sign? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 11:05 AM > Has anyone read 'Oracle8i for Dummies' ?? > I have checked it out from our local public library > It's not a bad read, I am still in chapter 1, though.. learning some new & > interesting analogies to this techie stuff.. > > - Kirti > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: OFF TOPIC: RE: PL/SQL
Kirti - I haven't read that book, but I haven't seen a bad book in the "for Dummies" series yet, so I would imagine it is pretty good, especially for beginners. Maybe after you have gone through it you can let us know your opinion, especially whether it is more for beginning Oracle developers or beginning DBAs. Book recommendation is a question that seems to recur on this list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 29, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new & interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L "beginner" should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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
Re: OFF TOPIC: RE: PL/SQL
Kirti, Too much time on your hands? Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' sign? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 11:05 AM > Has anyone read 'Oracle8i for Dummies' ?? > I have checked it out from our local public library > It's not a bad read, I am still in chapter 1, though.. learning some new & > interesting analogies to this techie stuff.. > > - Kirti > > -Original Message- > Sent: Tuesday, January 29, 2002 8:55 AM > To: Multiple recipients of list ORACLE-L > > > "beginner" should start with RTFM, trying it on test box, and only than, if > he still does not get it, post his question explaining his problems. > > Beth, you must not have seen Roland's questions. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, January 29, 2002 8:45 AM > > > > Roland, > > Besides reading the manuals, take a look at www.lazydba.com. They also > host an Oracle email list that might be a more appropriate forum for > your questions. I think they have a higher ratio of "new" DBAs on their > list, and seldom mind answering the "beginner" questions. > > HTH, > > Beth > > (was that so hard guys?) > > > -Original Message- > Sent: Tuesday, January 29, 2002 5:21 AM > To: Multiple recipients of list ORACLE-L > > > Hear hear ! You tell 'm, Kevin ! I'm with you all the way. > > Anybody can ask me a "simple" question when they are looking for a quick > answer, but you can't do a good job when you're always looking for quick > answers. You have to LEARN. There's a difference between learning and > constantly asking questions. > > Sorry, couldn't resist ... > > -Oorspronkelijk bericht- > Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] > Verzonden: dinsdag 29 januari 2002 9:00 > Aan: Multiple recipients of list ORACLE-L > Onderwerp: OFF TOPIC: RE: PL/SQL > > > When I arrive in the morning to a mailbox containing 150+ messages from > this list, I'm almost certainly guaranteed that 10% of them will be > questions that can easily be found via otn or a manual. That 10% usually > comes from the same person!! No wonder I'm irritated!!! > > }:o| > -Original Message- > Sent: 28 January 2002 17:35 > To: Multiple recipients of list ORACLE-L > > > > Geez... lay off already. If you don't think the question is worthy of > your time, then don't answer it. What a grouch. > > -Original Message- > Sent: Monday, January 28, 2002 11:16 AM > To: Multiple recipients of list ORACLE-L > > > RRR TTTFF > !! > > -Original Message- > Sent: 28 January 2002 15:46 > To: Multiple recipients of list ORACLE-L > > > How can I in a pl/sql block write null if I want null to be inserted in > a field when I use dynamic sql.? . I mean nothing is going to be > inserted. > > > > > Thanks in advance > > > Roland > > -- > 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: Thomas, Kevin > 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: Seefelt, Beth > 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 t
RE: OFF TOPIC: RE: PL/SQL
Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new & interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L "beginner" should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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
RE: OFF TOPIC: RE: PL/SQL
LOL...where's me soapbox!! I'm having a bad week, and hot-dang if everyone else ain't gonna suffer to!! ;o) TFIC! -Original Message- Sent: 29 January 2002 14:50 To: Multiple recipients of list ORACLE-L Kevin, I am sorry, but you didn't sound holier than thou on that last post. Could you do it a bit differently next time>? ;-) "WWJD? JWRTFM!" -Original Message- Sent: Tuesday, January 29, 2002 9:10 AM To: Multiple recipients of list ORACLE-L Hey I've helped this guy heaps of times...taken the time out to explain what I'm sending back to him and drop subtle hints about the references I use to get those answers if I don't know myselfwhy should he be any different??? -Original Message- Sent: 29 January 2002 13:45 To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE your
RE: OFF TOPIC: RE: PL/SQL
Voting him off the island... uh? ;-) -Original Message- Sent: Tuesday, January 29, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: OFF TOPIC: RE: PL/SQL
"beginner" should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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: Daemen, Remco INET: [EMAIL PROTECTED] Fat City N
RE: OFF TOPIC: RE: PL/SQL
Kevin, I am sorry, but you didn't sound holier than thou on that last post. Could you do it a bit differently next time>? ;-) "WWJD? JWRTFM!" -Original Message- Sent: Tuesday, January 29, 2002 9:10 AM To: Multiple recipients of list ORACLE-L Hey I've helped this guy heaps of times...taken the time out to explain what I'm sending back to him and drop subtle hints about the references I use to get those answers if I don't know myselfwhy should he be any different??? -Original Message- Sent: 29 January 2002 13:45 To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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
RE: OFF TOPIC: RE: PL/SQL
I think pretty much everyone on this list will answer beginner questions all day long. As a matter of fact, I have seen it. All we are asking for is a little effort from the poster before coming to the list. -Original Message- Beth Sent: Tuesday, January 29, 2002 5:45 AM To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-
RE: OFF TOPIC: RE: PL/SQL
Hey I've helped this guy heaps of times...taken the time out to explain what I'm sending back to him and drop subtle hints about the references I use to get those answers if I don't know myselfwhy should he be any different??? -Original Message- Sent: 29 January 2002 13:45 To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: OFF TOPIC: RE: PL/SQL
Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of "new" DBAs on their list, and seldom mind answering the "beginner" questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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: Daemen, Remco 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 l
RE: OFF TOPIC: RE: PL/SQL
Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a "simple" question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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: Daemen, Remco 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).