The moose likes Oracle/OAS and the fly likes Regarding Substring Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Regarding Substring" Watch "Regarding Substring" New topic

Regarding Substring

santhosh kumar vk
Ranch Hand

Joined: Aug 25, 2009
Posts: 150

I am doing sub string in oracle, while doing sub string a text the asterisk is not coming
for example i am giving input as "12345*, 1234, 45678" but it giving 12345
This is the code i was using REGEXP_SUBSTR("12345*, 1234, 45678",'(\w)+',1,l_loop_index);
i want output like

Could you please help me

Santhosh Kumar V.K
I agree. Here's the link:
subject: Regarding Substring
jQuery in Action, 3rd edition