Results 1 to 2 of 2

Thread: Extract String value

  1. #1
    Expert Member
    Join Date
    Sep 2005
    Answers
    206

    Extract String value

    Hello ,

    I am trying to get the value after second pipe from the following value using SQL in Oracle with instr function .. it's not working for me

    Could some one help me with syntax..

    this is the value 1|1|True
    this is the value 2|2|False

    I need to get True , False after second pipe form the value..

    Thanks,
    Suji


  2. #2
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    Re: Extract String value

    try this ....

    select substr(column name,instr(columnname , '|' , -1 )+1) from table name


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact