Home » SQL & PL/SQL » SQL & PL/SQL » Separate Alpha-Numeric Column into Alpha and Number
Separate Alpha-Numeric Column into Alpha and Number [message #239375] Tue, 22 May 2007 03:43 Go to next message
skkazmi
Messages: 44
Registered: April 2006
Member
Hi All,

I m using Oracle 9i database, i facing problem to separate alpha-numric column data into alpha n number. is their any build-in function in oracle 9i database to convert this column data separatly.

Khurram Kazmi
Re: Separate Alpha-Numeric Column into Alpha and Number [message #239377 is a reply to message #239375] Tue, 22 May 2007 03:51 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Don't double post !
You wont get any help faster by doing that
Re: Separate Alpha-Numeric Column into Alpha and Number [message #239381 is a reply to message #239377] Tue, 22 May 2007 04:02 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Don't be greedy: one thread per subject!

http://www.orafaq.com/forum/fa/448/0/

Closed.

MHE
Previous Topic: import command
Next Topic: Pls it urgent
Goto Forum:
  


Current Time: Mon Dec 05 02:57:30 CST 2016

Total time taken to generate the page: 0.13722 seconds