Meaningless Drivel is fun!*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Regarding Substring" Watch "Regarding Substring" New topic
Author

Regarding Substring

santhosh kumar vk
Ranch Hand

Joined: Aug 25, 2009
Posts: 144
Hi,

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
12345*
1234
45678

Could you please help me

Thanks,
Santhosh Kumar V.K
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding Substring
 
Similar Threads
Struts 2 parameter mapping issue
How to increase the colum width
Methods and Arrays Help
Regarding validation of field
check the output