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.

Report message to a moderator

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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Post the solution.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 23 07:28:07 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.