MySQL Forums
Forum List  »  Oracle

Re: Funcion INSTR
Posted by: Dmitry Tolpeko
Date: August 18, 2009 12:58PM

>I need to know the number of occurrences of ',' in each row

I am afraid, in your sample Oracle INSTR does not return the number of occurrences, it returns the <position> of the second occurrence of comma.

Kind regards, Dmitry

Options: ReplyQuote


Subject
Views
Written By
Posted
9373
August 16, 2009 12:00PM
6712
August 17, 2009 02:38PM
3940
August 18, 2009 10:34AM
Re: Funcion INSTR
3761
August 18, 2009 12:58PM
4099
August 18, 2009 04:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.