Home » SQL & PL/SQL » SQL & PL/SQL » regexp_10g (merged)
regexp_10g (merged) [message #313891] Tue, 15 April 2008 01:23 Go to next message
maham_158
Messages: 5
Registered: January 2008
Junior Member
Hi All,

I am trying to split one column into two columns. i have to use regexp as i am using 10g
For example
A
------------------------
10-15
23-78
12-45

Required output

B C
-------------------------------------------
10 -15
23 -78
12 -45
Re: sql expert [message #313893 is a reply to message #313891] Tue, 15 April 2008 01:32 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
why REGEXP only???.Can you post what you tried.And don't forget to format your post.


regards,
Re: regexp_10g [message #313894 is a reply to message #313891] Tue, 15 April 2008 01:35 Go to previous messageGo to next message
maham_158
Messages: 5
Registered: January 2008
Junior Member
Hi all,

i do format it but when i post it, it changes. Please can you let me know how can i keep the formatting even after post. I think i have to change somthing for my explorer.

Best Regards,
Re: regexp_10g [message #313895 is a reply to message #313894] Tue, 15 April 2008 01:40 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read OraFAQ Forum Guide, "How to format your post?" section, there is example of how to use code tags.

There is a Test forum to test your post before really posting it.

Regards
Michel
Previous Topic: Department wise 2 max salary
Next Topic: Whats the difference between Relational database and Multi dimensional databse?
Goto Forum:
  


Current Time: Fri Dec 09 17:06:35 CST 2016

Total time taken to generate the page: 0.26626 seconds