String manipulation

2004-01-26 Thread Stefick Ronald S Contr ESC/HRIDA
Title: String manipulation





I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3


Here is the code so far:
 1 select substr(subject,1,instr(subject,'~')-1) first,
 2 substr(subject,instr(subject,'~')+1, instr(subject,'~',1,2)-1) second,
 3 substr(subject,instr(subject,'~',1,2)+1,length(subject))
 4 from test_table
 5 where test_column=1700455


The result I get is:
mystr1
mystr2~mystr3
mystr3


The result I want is:
mystr1
mystr2
Mystr3


TIA,


Scott Stefick
MILPDS OCP Oracle DBA
[EMAIL PROTECTED]
210-565-2540





RE: OT : Happy Spring Festival

2004-01-21 Thread Stefick Ronald S Contr ESC/HRIDA
Title: RE: OT : Happy Spring Festival





At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl.



-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 21, 2004 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT : Happy Spring Festival



On 01/21/2004 07:20:00 AM, Stephane Faroult wrote:
 ... to whomever is concerned ...
 
 Regards,
 
 Stephane Faroult
 Oriole


Spring??? What is spring? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
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: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Stefick Ronald S Contr ESC/HRIDA
Title: RE: Re[2]: another OCP question -- help me guys





Uh No one can be at Rachel's level. She's the DBA Goddess






-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 07, 2004 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: another OCP question -- help me guys



A small but growing number of employers want certification. Considering the job market, I recommend anyone who is not at Rachel's, etc.. level to get certified as both a developer and a DBA. I'm doing Java also, just to have it. The java test is a total joke. You only need to get 52% right and its just one test, but people want it. You really don't even need to know java. Just object-oriented programming and memorize a bunch of fairly useless information.

Getting a good salary is more about your resume and how well you speak than it is about your skill set. I've had alot of technical interviews and they all seem to ask the same easy questions. They are interested in: years of experience, degree, where your degree is from, certification, and in some cases where you worked before. There is some bias in the DC area for 'top 5' consulting. I think that means Booz Allen, and Ernst and Young. Not sure who the other 3 happen to be.

People don't seem to be all that interested in whether you can actually do the job. They just assume your better than someone else if you have a nicer resume.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:34 AM



 I didn't mean to scold... you post way more information than I usually 
 do!

 And I answer whilst eating breakfast at times too :)

 Richard *is* right, the problem is, the sql statement is misformed but 
 the answer key says it will work. Which is yet another reason I 
 dislike the OCP exams.


 --- Jonathan Gennick [EMAIL PROTECTED] wrote:
  Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
  ([EMAIL PROTECTED]) wrote:
  RC I successfully use drop tablespace including contents and
  datafiles
  RC all the time. And a quick check of the docs shows that cascade 
  RC constraints is valid but, as Richard said, belongs at the end 
  RC of
  the
  RC statement.
 
  I stand corrected, though I did admit up front to not having checked 
  the manual. I was eating breakfast at the time, so forgive me that 
  one lapse.
 
  I liked Richard's point about trusting what you see. He was spot on 
  with that comment, at least in this context.
 
  Best regards,
 
  Jonathan Gennick --- Brighten the corner where you are 
  http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
  Join the Oracle-article list and receive one
  article on Oracle technologies per month by
  email. To join, visit 
  http://four.pairlist.net/mailman/listinfo/oracle-article,
  or send email to [EMAIL PROTECTED] and include the 
  word subscribe in either the subject or body.
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]
 
  Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  San Diego, California -- Mailing list and web hosting services
  
  -
  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).


 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes 
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]

 Fat City Network Services -- 858-538-5051 http://www.fatcity.com
 San Diego, California -- Mailing list and web hosting services
 -
 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.net
-- 
Author: Ryan
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
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 

RE: test

2003-12-04 Thread Stefick Ronald S Contr ESC/HRIDA
Title: Message



Test failed

  
  -Original 
  Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, December 04, 2003 1:55 PMTo: Multiple 
  recipients of list ORACLE-LSubject: testtest