Home » Developer & Programmer » Forms » Row convert into column
Row convert into column [message #653847] Wed, 20 July 2016 04:49 Go to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Dear all,

"00160000001954 001024 999999950203608806901 999 999950 95020360 02036088069 3608806901"

in above string 8 value for me .
now i want to convert this string into column like

column 1 column 2 column 3 column 4 column 5 column 6 column 7 column 8
00160000001954 001024 999999950203608806901 999 999950 95020360 02036088069 3608806901



please any one help me about it.
Re: Row convert into column [message #653848 is a reply to message #653847] Wed, 20 July 2016 05:27 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Done it with regexp_substr.
Re: Row convert into column [message #653851 is a reply to message #653848] Wed, 20 July 2016 07:48 Go to previous message
Michel Cadot
Messages: 67467
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the solution.

Previous Topic: Format Mask for IP
Next Topic: use of API in oracle forms
Goto Forum:
  


Current Time: Tue Oct 27 01:53:29 CDT 2020